MVSFORUMS.com

[Packi]

I need to execute the following sql query through REXX:

Insert into table2 (select * from table1 where not exists(select * from table2 where table1.keyfield1 = table2.keyfield1))

i tried dynamically creating this sql in a variable. Then i prepared and executed this. It is giving SQLCODE of -104 while executing. But the SQL is fine when running in spufi.

[jim haire]

The query looks good. A -104 usually says that the SQL is not formatted quite correctly.

I would try the following options:
1. Put a Trace in your program and see what the contents of the variables are.
2. Use a "SAY variable" statement to see what the SQL looks like on your
screen.
3. Write your variable to a file and then turn HEX ON to verify that you don't
have any invalid characters in your SQL.

[vivek1983]

Packi,

Can you post an excerpt of your rexx code where this query is prepared and declared?
_________________
Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay)

[Packi]

SQL6=Insert into table2 (select * from table1 where not exists(select * from table2 where table1.keyfield1 = table2.keyfield1))


ADDRESS DSNREXX "EXECSQL PREPARE S6 FROM :SQL6"
SAY 'RC:' RC
SAY 'SQLCODE:PREPARE(UPDATE)' SQLCODE

ADDRESS DSNREXX "EXECUTE S6"
SAY 'RC:' RC
SAY 'SQLCODE:UPDATE' SQLCODE*/

[Nic Clouston]

put quotes around your statement when assigning it to variable SQL6 e.g.

SQL6 = "INSERT INTO TABLE......."
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.