what is the soft code for deadlock ?
Answers were Sorted based on User's Feedback
Answer / deepthy
-911 and -913 are the sqlcodes for deadlock. But DB2 attempts
to roll back the SQL for one of the application
processes. If the
ROLLBACK is successful, that application receives
SQLCODE -911. If the
ROLLBACK fails, and the application does not abend,
the application
receives SQLCODE -913.
| Is This Answer Correct ? | 4 Yes | 0 No |
What are some SQL aggregates and other built-in functions?
What are the various locking levels available?
What is a clustered index?
Can any one tell me about Restart logic in DB2.
What is referential integrity?
What is cobol db2?
Explain about rct in db2?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
can i code union in cobol-db2 pgm ?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
What is the difference between Where and Having Clause