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
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)
When you got SQLCODE that retreive from DB2 you can use following command for describe
DB2 ? SQL-<ERRORCODE>
example
DB2 ? sql-407
精彩评论