REXX/DB2 SQL - 104 Help

[Ed Benoit]

Hello All,
I know I am doing something stupid, but my insert do not like my timestamp.
I did not get it from set current timestamp because I attempted and gave up
and made the timestamp that is appropriate for DB2 timestamp format but it do
not like something. Look like it do not like my .23 in the time area.

My sql statement:

"EXECSQL INSERT INTO RKI.RKIHISTORY (RDBASE,RTBLSP,RTORBA, RZUSER,RDATE)
VALUES (RKIDB01,RKITS01,TORBA,IBMUSER,2004-10-12-17.39.23.606303)"

DB2 message:
SQLCODE = -104
SQLERRMC = .23 ) ,

Help,
Ed.

----------------------------------------------------------------------
For TSO-REXX subscribe / signoff / archive access instructions,
send email to LIST...@VM.MARIST.EDU with the message: INFO TSO-REXX

[Robert Zenuk]

In a message dated 10/12/2004 5:56:40 PM US Mountain Standard Time,
Ibm...@AOL.COM writes:

"EXECSQL INSERT INTO RKI.RKIHISTORY (RDBASE,RTBLSP,RTORBA, RZUSER,RDATE)
VALUES (RKIDB01,RKITS01,TORBA,IBMUSER,2004-10-12-17.39.23.606303)"

Try this:

"EXECSQL INSERT INTO RKI.RKIHISTORY (RDBASE,RTBLSP,RTORBA, RZUSER,RDATE)

VALUES ('RKIDB01','RKITS01','TORBA','IBMUSER','2004-10-12-17.39.23.606303')"

or

db = 'RKIDB01'
ts = 'RKITS01'
RBA = 'TORBA'
USER = 'IBMUSER'
TSTAMP = '2004-10-12-17.39.23.606303'

"EXECSQL INSERT INTO RKI.RKIHISTORY (RDBASE,RTBLSP,RTORBA, RZUSER,RDATE)

VALUES ("db","ts","rba","user","tstamp")"

Additionally, try using the ISPF Edit HILITE option to see what is code and
what is literals.

Rob