com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=426

vasavshah · #1 (**permalink**) 01-19-12, 01:41

I am trying to insert a record in the table using the following query

INSERT INTO XXXXX (ID,NUM,NUM,ST_CD, ID,TSTMP,TXT,ID) VALUES ('CID-00AB245',1,'820C53B','12','ENT01',(CURRENT TIMESTAMP–CURRENT TIMEZONE),'<Tag>This is the transaction XML.</Tag>','10e9d8da-f50f-4d81-b033-ad571d08a9a6')

com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=–;MICROSECONDS MICROSECOND SECONDS SECOND MINUTES MINUTE HOURS, DRIVER=3.61.107

I m not able to find out the reason for failure. Pls help me out

przytula_guy · #2 (**permalink**) 01-19-12, 02:13

not knowing the layout of the table this seems correct
try to put this statement in a local file and execute the insert locally...
see the error ..

vasavshah · #3 (**permalink**) 01-19-12, 02:18

I did run the query on the local and found the following error..Please let me know if posting the table sturucture will help to resolve the issue

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "–" was found following "". Expected tokens may
include: "( CONCAT || / MICROSECONDS MICROSECOND SECONDS SECOND MINUTES".
SQLSTATE=42601

SQL0104N An unexpected token "–" was found following "". Expected tokens may include: "( CONCAT || / MICROSECONDS MICROSECOND SECONDS SECOND MINUTES ".