⟩ Explain What are the two types of OLTP?
TP lite, based on stored procedures. TP heavy, based on the TP monitors.
TP lite, based on stored procedures. TP heavy, based on the TP monitors.
What are the disadvantages of PAGE level lock?
What is a precompiler?
What is the diff bet plan,package,dbrm?
Give the COBOL definition of a VARCHAR field.
When can an insert of a new primary key value threaten referential integrity?
What is the self-referencing constraint?
Is DECLARE CURSOR executable?
What are foreign keys in DB2?
A user defined name that is the anchor for packages. It has not physical existence. Main usage is to group packages. In SPUFI suppose you want to select max. of 1000 rows , but the select returns only 200 rows.
What is sqlcode -811?