CODEWITHSUNDEEP
sqldb2sqlcode
Gourav
Gourav

Reputation: 1081

What does SQLCODE: -516 signify

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

Upvotes: 0

Views: 10187

Answers (2)

Fuangwith S.
Fuangwith S.

Reputation: 5764

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

DB2 ? SQL-<ERRORCODE>

example

DB2 ? sql-407

Upvotes: 2

Brian Agnew
Brian Agnew

Reputation: 272417

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)

Upvotes: 4

Related Questions