Q:
DB2 update query giving error STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX.
The following sql query in DB2 is giving the exception. What can be the correct query for this in DB2?
SQLQuery=update EMP set validityenddate='01-JAN-07' WHERE username='XYZ'
Exception:
msg=java.sql.SQLException: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX.
SQLQuery=update EMP set validityenddate='01-JAN-07' WHERE username='XYZ'
Exception:
msg=java.sql.SQLException: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX.
ASKED:
Nov 13 2008 1:24 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
+1
Click to Vote:
+1
Click to Vote:
- 1
0
Have a look at this article which explains, among other things, how to change the default date format.
You also have to note the datatype for this field on the database table EMP.
If the data type is TIMESTAMP, then the only correct way to set this column is by using the following format:
'YYYY-MM-DD-hh.mm.ss.000000' where 000000 correspond to the fractions of second.
If the data type is DATE then you should attain to the territory code of the database.
To get the territory code of the database, the database administrator should run the following command:
GET DATABASE CONFIGURATION FOR <database-alias>
To get the table definition the developer can run the following command, from the Command Center or the Command Window:
DESCRIBE TABLE EMP
