Showing posts with label sql error. Show all posts
Showing posts with label sql error. Show all posts

DB2 SQLCODE -305

Mainframe db2 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.

What is -818 SQLCODE & how to resolve it?

-818 SQLCODE

Time-stamp mismatch between PLAN and load module.
Solution - Rebind the given component.

-911 SQLCODE

-911 SQLCODE

Deadlock.
Given task will go in deadlock, when resource is not available for long time.

-904 SQLCODE

-904 SQLCODE

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.

-803 SQLCODE

-803 SQLCODE

Duplicate record while INSERT.
db2 SQL query will throw this error while inserting duplicate record into db2 table.

SqlCode 92J in db2 cobol program.

SqlCode 92J in db2 cobol program.

-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.