Mention the downsides of page level lock.
No Answer is Posted For this Question
Be the First to Post Answer
Can any one tell me about Restart logic in DB2.
How to know the primary key of a table without defining the primary key in the table?
Why select is not preferred in embedded sql programs?
What's the maximum number of volumes that can be added to a STOGROUP?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is a DB2 bind?
What is cascading rollback?
What is QUIESCE?
What is the STOSPACE Utility used for?
wht steps we need will coding cobol and db2 pgm ?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
Could anyone clearly explain the diference between sub query and correlated sub query?