What does SQLCODE: -516 signify

9.3k Views Asked by At

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

2

There are 2 best solutions below

0
On

When you got SQLCODE that retreive from DB2 you can use following command for describe

DB2 ? SQL-<ERRORCODE>

example

DB2 ? sql-407
1
On

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)