Top "Sqlcode" 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 …

java sql db2 sqlcode jcc

DB2 SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH203 0X5359534C564C3031

I am getting this error below : com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.…

database db2 sqlcode

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 …

sql database db2 sqlcode

DB2 Logfile Limitation, SQLCODE: -964

I have tried a huge insert query in DB2. INSERT INTO MY_TABLE_COPY ( SELECT * FROM MY_TABLE); Before that, …

database db2 logfile sqlcode

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, …

sql db2 sqlcode

db2 Error sqlcode: -1224

Has anyone seen this type pf error msg before. I cannot find documentation on sql code -1224? DB21034E The …

db2 sqlcode

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 …

sql db2 sqlcode