• RPGLE Embedded SQL Not null

    RPGLE Embedded SQL is getting a SQL0305 (SQLcid-305, sqlstate 22002) when fetching the next record from a view. This is pointing to null values encountered.  /free                                                   exec...

    NickHutcheson11,380 pointsBadges:
  • SQL Studio Express scheduled backup

    I need a scheduled backup for a standalone SQL database on an XP Pro PC. I have Studio Express installed and this does not have a scheduling utility. Can anyone suggest a way of achieving this without the expense of an SQL Express license

    James015 pointsBadges:
  • IN and Exists in SQL?

    What is the difference between IN and EXISTS IN SQL? I googled but I dint get good information. PLease provide me the exact deifference between them.

    Prcvjr220 pointsBadges:
  • SQL table in RPG

    I need to read an SQL table (file) in RPG and select certain records. I'm pretty green in SQL. Anyone have a sample they could share? I'm better at RPG than ILE but I'll take what I can get. Thanks!

    Brenger170 pointsBadges:
  • Update a Date_Time Field

    I'm trying to update a DATE_TIME field to a NULL value. When I run the script below I get an error. Any ideas on what I'm missing? UPDATE Orders SET CONFIRMATION_DATE_TIME = ' ' WHERE ST_ID = 102690 ERROR: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value 'Ê' to a column...

    DJandLO130 pointsBadges:
  • Multiple Join Update

    Hi, my need is to update a table with a join of 2 other tables. The first table (a) has 5 columns (product_id number, ist number, plan number, plan_w number, ist_w number) The second table (b) has 2 columns (prod_group_id number, percent number) The third table (c) has 2 columns (product_id number,...

    Keltos25 pointsBadges:
  • Help joining data into table 1 from table 2 SQL

    I have 2 tables, table1 has columns A,B,C,D and table2 has columns B,C,D, I want to update table1 column A with table2 column B, where table1 c,d matches table2 b,c. I hope that was clear.

    JustAnotherITguy60 pointsBadges:
  • AS/400-SQL/400 query

    Write an SQL query to the 6th highest salary of employee? I know how to write query for 6th highest salary of employee but it's too lengthy. Can any one simplify this query please. 2nd highest salary: select max(esal) from emp where esal <(select max(esal) from emp) 3rd highest salary: select...

    chowas400615 pointsBadges:
  • SQL Server 2005 or 2008?

    I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...

    Habana5 pointsBadges:
  • RUNSQLSTM

    I'm executing a RUNSQLSTM out of a CL program that run a source SQL statement in a source file of a library. Everytime the statement is executed I get a output spool file of the SQL parmeters and execution results. How can I prevent this?

    Abbey120 pointsBadges:
  • Linking and unlinking SQL data

    How do link data from a SQL view?

    lsizemore5 pointsBadges:
  • Nested XML question

    I am working on a big project that needs to output multi-level nested XML. I'm running into an issue when trying to go past 2 levels.deep. The SELECT uses 4 different tables; one for each level. My question is: Is it best to use FOR XML PATH or FOR XML EXPLICIT when trying to create XML that is...

    CeeGee5 pointsBadges:
  • Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system?

    We are having an ETL process which inserts lots of data into tables. This database is set to Simple Recovery Model and the transaction log is growing a lot. I was thinking that would it help to set this database into Bulk-Logged Recovery Model? We are taking full backups on daily basis. So is there...

    bugarl5 pointsBadges:
  • using group by by joining 2 tables SQL

    there are two tables employees and jobs .employees table attributes are job_id and salary.jobs having attibute job_id,job_title.i want to retrieve sum(salary),job_title  group by job_id

    Lak5 pointsBadges:
  • SQL question

    One table named as employee has 3 columns (name, salary, department). I need to retrieve the employees whose salary is greater than average salary of their department. that is name    salary   department iioo      10000    Technical aaaa    15000     HR pppp    17000    ...

    Hema19865 pointsBadges:
  • Converting date time in C#

    hi all, I have a column called WBsstartdate (storing dates), that has been created as a Varchar data type. If I run a convert on the table, my date comes out in the right format. (Eg: 2006-04-03 00:00:00). This is fine. However when I run this date as an sql query in a programme in C#, and save to...

    Zubairm765 pointsBadges:
  • convert SQL datetime to date only

    Using SQL, how can I convert a data in a datetime field to a date only data? When I run a job to collect data, I use the getdate() function that returns the date and time. I want to then convert this to the same date but with a time of 00:00:00. Please advise. Thanks! ~Gina

    Gina35 pointsBadges:
  • Crosstab query in SQL

    How to make crosstab in my sql?

    Tafz085 pointsBadges:
  • SQL MS Access – Displaying output in a certain order

    Hi Team, SELECT mergeddatabase.Roomno, Count(*) AS Boxesscanned, Sum(mergeddatabase.Currentweight) AS RoomsTotalweight, mergeddatabase.Currentdate AS RequestedDate FROM mergeddatabase WHERE (((mergeddatabase.Currentdate) Between [Forms]![FrmDateRange]![TxtStartDate] And...

    Witsend10 pointsBadges:
  • Oracle RR Date Format

    Can anyone tell me about RR Date format in Oracle 9i (SQL)?

    JOGENDER20095 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following