• DB2 to SQL conversion

    How to I convert DB2 to SQL?

    cgardel015 pointsBadges:
  • Upgrading Forms30 on Oracle 7.0

    I am upgrading Forms30 on Oracle 7.0 to Oracle 10g First, I am upgrading to Oracle forms 6i using Forms compiler and facing these problems: Converting language on display item. (it doesn't show the right language on display item and headers) Key mapping function. I need script so I can convert all...

    Oikhleif30 pointsBadges:
  • SQL statement using RRN(file) on join pulling only Max(date) records from second file in iSeries

    I am using WebSmart with the I-series data base files. I am joining two data base files receiving the RRN so that I can use the fetch rrn and the fextnext to display one screen at a time in my WebSmart program. I have used this method many times except this time I have a one to many relationship...

    Isjld35 pointsBadges:
  • New to SAS need date equivelant for script in proc SQL

    I need what the SAS equivalent for this is: to_char (COLLECTION_ENTRY_DATE,'month/yy')as Entry_Month_Y,to_char(COLLECTION_ENTRY_DATE,'DD')asDAY_entry. I have tried putting COLLECTION_ENTRY_DATE,monyy5.) and different variations but without success can you advice? Full script is: proc sql; create...

    cyrus20075 pointsBadges:
  • Using SQL to insert records into a table

    I have a table with a period in the table name, i.e. AB.CDE that I need to insert some records into. When I query the table (Select * from "AB.CDE") it works fine. When I try to insert records (insert into "AB.CDE"), however, I get a file not found message. Does anybody know why this is happening?

    GaryF60 pointsBadges:
  • Delete all data in the database

    Good day! Currently I am using MS SQL Server 2000. I wish to delete all data in the database table except data in login table and security table. Furthermore, TRUNCATE is done on stand-alone and child tables, else DELETE if table has any foreign key references (normally refer to parent tables): Is...

    Hunkgym5 pointsBadges:
  • Need to create SQL DTS Package

    We are using SQL 2000 DTS Packages and I want to create a DTS Package which can copy only all text file names from folder(source) to SQL table column(Destination). Also, I want to write number of rows in particular text file to SQL table. DTS or Procedure or Activex Script?

    JimmyIT1,725 pointsBadges:
  • ORA-00604: error occurred at recursive SQL level 1 ORA-01555: snapshot too old: rollback segment number 0 with name \

    I am getting this error in my system: ORA-00604: error occurred at recursive SQL level 1 ORA-01555: snapshot too old: rollback segment number 0 with name. How can I resolve this issue?

    chethanhb5 pointsBadges:
  • 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,390 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...

    chowas400620 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:

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.

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

Following