Runstats utility updated the catalog tables with the statistical information.
SYNCPOINT command is used to commit a transaction in CICS program.
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.
If a user is not authorized to access DB2 objects, he will face SQLCODE -922.
When you will try to insert or update a record with duplicate key then you will face SQLCODE = -803.
Application plan consists of one or more DBRM & application package which is kept in buffer pool during program execution.
We will bind only that package which contains the modified DBRM. No need to bind all the packages. /p>
Bind step converts all the SQL statements into executable form in COBOL-DB2 program.
A negative SQL code indicates a failure while a positive one indicates an exception. /p>
REVOKE statement is used to take away the permissions from a Database.
GRANT keyword is used to grant privileges on DB2 tables.
Primary keys are optional and we can define them in CRETAE TABLE & ALTER TABLE statements.