What does SQLCODE: -516 signify

sql db2 sqlcode
Gourav picture Gourav · Oct 19, 2009 · Viewed 7.7k times · Source

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

Answer

Brian Agnew picture Brian Agnew · Oct 19, 2009

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)

Related questions

What can SQL CODE -104 (error) represent?

I am executing an SQL query via jcc to run a report. When I opened the error log file for the program and examined the SQL query, everything seems to be fine (There are no extra or missing brackets, commas, …

Read More
DB2 Error SQLERRMC:DECFLOAT... sometimes

This one really has me scratching my head. This statement: SELECT CODE FROM CODES_TABLE WHERE STATUS = 0 AND PERCENT = 30 works just fine, but this one: SELECT CODE FROM CODES_TABLE WHERE STATUS = 0 AND PERCENT = 20 Gives me the DB2 SQL Error: …

Read More
how to check which column cause db2 22001 error?

Good day, org.springframework.dao.DataIntegrityViolationException: could not insert: [com.entity.payment.BPaymentItem]; SQL [insert into sc.PHistoryItem (amount, beneficiaryAccNo, beneficiaryBankCode, beneficiaryBankName, beneficiaryRef2, billCode, branchId, chargeTo, cibRefNo, cifId, collectionAccountNo, companyId, companyName, createdHostDateTime, currentStatus, customerCategoryCharges, customerCategoryCode, customerCategoryId, customerCategoryName, description, errorCode, errorMessage, …

Read More