0

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

Joachim Sauer
  • 302,674
  • 57
  • 556
  • 614
Gourav
  • 1,061
  • 2
  • 13
  • 16
  • 1
    What was wrong with IBM's DB2 documentation? What part of the reference manual for DB2 was confusing or incomplete? – S.Lott Oct 19 '09 at 10:28

2 Answers2

4

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
  • 268,207
  • 37
  • 334
  • 440
  • 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 Oct 19 '09 at 10:54
2

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

DB2 ? SQL-<ERRORCODE>

example

DB2 ? sql-407
Fuangwith S.
  • 5,654
  • 8
  • 37
  • 41