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?

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

AN:
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 is meant by repeatable read?
• What information is held in SYSIBM.SYSCOPY?
• What is the database descriptor?
• What do you mean by NOT NULL ? When will you use it ?
• What is normalization and what are the five normal forms?
• What are delete-connected tables ?
• What types of copies can be made with the COPY Utility?
• How do you define a correlated name ?
• What is the purpose of the WHENEVER statement?
• What are the various locks available?
• More...