MVSFORUMS.com

ASHOKRAJ · Beginner Joined: 15 Dec 2008 Posts: 2 Topics: 1

Hi,
Need to Insert rows into a DB2 table,which accepts NULL value in few columns - Using REXX. Struck up with this..

Below is the REXX code, having declaration, preparation and execution statements
REXX CODE

Nic Clouston · Posted: Thu Feb 05, 2009 10:14 am Post subject:

If you read the manual you will find that it says that a Rexx null IS NOT THE SAME as a DB2 null. To insert a NULL into DB2 you have to set the null indicator to a negative value.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

kolusu · Posted: Thu Feb 05, 2009 11:04 am Post subject:

ASHOKRAJ,

-104 is a syntax error. Use TRACE to display the generated SQL statement; also, display SQLERRM to see some more info.

Kolusu

ASHOKRAJ · Beginner Joined: 15 Dec 2008 Posts: 2 Topics: 1

Hi kolusu,
How to use the TRACE for display? Also I have directly tried displaying SQLERRM, it is not getting the value...hope below lines need modification..

-------------------------------
IF LASTSQL /= '0' THEN DO
SAY 'Insertion not success'
SAY 'SQLERRM is:' SQLERRM
END
-------------------------------

Regards,
Ashok

Nic Clouston · Posted: Fri Feb 06, 2009 2:58 pm Post subject:

Look up the Rexx Language Reference for the TRACE command
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.