How do you specify and use a cursor in a COBOL p

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How do you specify and use a cursor in a COBOL program? –

Use DECLARE CURSOR statement either in working storage or in procedure division(before open cursor), to specify the SELECT statement. Then use OPEN, FETCH rows in a loop and finally CLOSE.

(Continued on next question...)

Other Job Interview Questions

• How does DB2 determine what lock-size to use?
• Is BETWEEN inclusive of the range values specified? –
• What is a DBRM, PLAN ?
• How To perform Performance Tunning on COBOL-DB2 program ?
• How does DB2 store NULL physically?
• How would you retrieve rows from a DB2 table in embedded SQL? –
• What are the isolation levels possible ?
• How do I create a table MANAGER ( EMP#, MANAGER) where MANAGER is a foreign key which references to EMP# in the same table? Give the exact DDL.
• At what stage DB2 must be up?
• How to increase table space in DB2?
• More...