Joined: 20 Oct 2006 Posts: 6970 Location: porcelain throne
The following is from the -104 description and response paragraphs,
which obviously you have read:
Quote:
A syntax error in the SQL statement was detected at 'token'
Examine the statement in the area of the specified token.If you are executing the SQL statement dynamically under TSO, be sure that if the data set containing the DSNHDECP load module has not been included in your LINKLSTxx, it has been included in STEPLIB statements in:1. The DB2 start-up procedure 2. The TSO logon procedure or batch job JCL.
since you have not bothered to provide us with ANY information about
what are you trying to do what does the data look like what does the ddl for the table look like
Can Anyone please help me out with what this error means while DB2 insert-
SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: ,;( + - ? : CASE CAST NULL USER <FLOAT> CURRENT DEFAULT NEXTVAL
Any chance you could cut and paste the original sql statement so we could see it.
Hi Craq,
Fot security reasons I cannot post the insert statement,It has 90 columns with the following datatypes : DECIMAL(10,0)
CHAR(4)
DATE
CHAR(3)
CHAR(7)
CHAR(2)
CHAR(6)
CHAR(1)
DECIMAL(15,2)
CHAR(9)
DECIMAL(15,0)
CHAR(10)
VARCHAR(120)
TIMESTAMP
is IHD_D a nullable column
if not, you have forgotten a value.
Yes the column is nullable and the two column names are NOT identical,I am extreamly sorry that while sanitising the data it was a mistake on my part to put identical column names...
Joined: 01 Dec 2006 Posts: 726 Location: Pennsylvania
soumen2255,
Do you understand the problem here?
You have a SYNTAX ERROR in your insert statement.
Nobody here can help you if:
1) You can not give the actual statement (for security purposes of course)
2) Give a santisized version of the statement (it has now been changed)
Even so, the actual (not santized) and complete error message is what really is required.
For security reasons I cannot post the insert statement
given the names of the columns I would say ... security by obfuscation
such poor/confusing naming conventions are prone to cause lots of pain to the developers
