I am able to retrieve data from the same database table but am not able to isert The error which i get is
DB2 SQL error: SQLCODE: -516, SQLSTATE: 26501, SQLERRMC: null
+3
A:
IBM's documentation suggests that
the currentSchema property does not match the schema name of the tables and indexes that you created.
(Although the above is for z/OS, I would expect that the Java DB2 implementation is the same)
Brian Agnew
2009-10-19 10:27:02
Thanks ..Its actually ment that there is a mismatch of columns.I was inserting 17 columns through frontend while in the backend there was one more extra coloumn.
Gourav
2009-10-19 10:54:32
+1
A:
When you got SQLCODE that retreive from DB2 you can use following command for describe
DB2 ? SQL-<ERRORCODE>
example
DB2 ? sql-407
Fuangwith S.
2009-10-20 04:25:40