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.
Showing posts with label sql error. Show all posts
Showing posts with label sql error. Show all posts
What is -818 SQLCODE & how to resolve it?
-818 SQLCODE
Time-stamp mismatch between PLAN and load module.
Solution - Rebind the given component.
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.
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.
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.
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.
-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.
Subscribe to:
Posts (Atom)