SQL Error Codes

DB2 - Important SQLCODES

DB2

+100 -> End of cursor

-180 -> String representation of DATE, TTIME, TIMESTAMP is invalid

-204 -> Object not defined to DB2

-205 -> Column name not in specified DB22 table

-206 -> Column does not exist in any tabble in the SELECT

-551 -> Not authorized to access DB2

-803 -> Unquie index voilation. Try to iinsert duplicate record.

-805 -> DBRM or PACKAGE not found in PLAAN

-811 -> Cursor should be used , when morre than one row returned as an result
of an singleton SELECT query

-818 -> Timestamp mismatch between plan and load module


IMP QUESTIONS ON ERROR CODES

Q. What is error code for end of record/record not found in DB2?
A. 100

Q. Then How you will find that, Error is for end of record or record not found?
A. If we are using select statement, sql error code 100 represents record not found
If we are using cursor , in that situation, sql error code 100 represents end of records