How do you leave the cursor open after issuing a

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

(Continued from previous question...)

How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only )

Use WITH HOLD option in DECLARE CURSOR statement. But, it has not effect in psuedo-conversational CICS programs.

(Continued on next question...)

Other Job Interview Questions

• What happens when you say OPEN CURSOR?
• How would you retrieve rows from a DB2 table in embedded SQL? –
• Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project?
• A VARCHAR column REMARKS would be defined as follows:
• Where is the output of EXPLAIN stored? –
• Can I use LOCK TABLE on a view?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• How do you find the maximum value in a column in DB2?
• Give some example of statistics collected during RUNSTATS?
• What is a synonym ?
• More...