SQLCODE -007
Invalid character in given SQL query.
Solution : - To avoid this error, correct the given character.
SQLCODE -010
Missing string terminate.
Solution :- Terminate the given SQL statement with proper string terminator keyword
SQLCODE -029
INTO clause is missing in SELECT query.
Solution :- Add the INTO clause in given query.
SQLCODE -101
Given SQL query is too large and complex.
Solution :- Avoid the complex queries make them simple.
SQLCODE -105
Invalid String in given SQL query.
Solution : - Recheck the given Query.
SQLCODE -117
Mismatch between the assigned values and columns in given INSERT or UPDATE SQL query.
Solution :- Correct the Query with correct number of values and columns.
SQLCODE -305
Null indicator is missing in given SQL query. Given query is returning a NULL value.
Solution :- Handle the null indicator while retrieving the data using SQL query.
SQLCODE -803
Duplicate record while INSERT.
db2 SQL query will throw this error while inserting duplicate record into db2 table.
SQLCODE -805
This sqlcode code indicates than DBRM not found. DBRM/package not found in given Plan
Solution - Bind the corresponding component.
SQLCODE -818
Time-stamp mismatch between PLAN and load module.
Solution - Rebind the given component.
SQLCODE -904
Resource not available.
db2 SQL query will throw this error while db2 resource is not available.
Solution - Delay the given query and retry for the operation.
SQLCODE -911
Deadlock.
Given task will go in deadlock, when resource is not available for long time.
SQLCODE 92J or 922
-92J - authorization failure with DB2 connection.
In order to resolve this issue, given userid should have access to given db2 Plan under given db2 schema.
