DB2 Interview Questions and Answers For Freshers Part-3
If a user is not authorized to access DB2 objects, he will face SQLCODE -922.
SYNCPOINT command is used to commit a transaction in CICS program.
Uncommitted read provides maximum concurrency.
Repeatable Read ensures highest data integrity as it holds page and lock the rows until a COMMIT point.
A transaction gets an Exclusive lock when it is about to write at that time no other lock can be applied on it.
DBRM is the input to the bind process which is produced in the pre-compile step.
SELECT COUNT(*) FROM TAB query is used to count the number of rows in a table.
When we use ALTER statement for adding a new column then it will be added at the end of the table.
We can declare a cursor either i Working Storage Section or in Procedure Division also.
SQLCODE -818 is a timestamp mismatch of load module and bind timestamp built from DBRM.