When is the results table for the query in a DECLARE CURSOR
statement created?

Answer Posted / mehdee

It is not OPEN CURSOR is executed, it is the 1st FETCH.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

B37 abend during spufi?

992


What are the full forms of spufi and dclgen and why are they used?

666


What is db2 connect?

616


Explain what are the various isolation levels possible?

616


What is the purpose of using commit?

629






What is the maximum length of sqlca?

886


Name the various locking levels available?

642


How do I create a view in db2?

616


What is the difference between using bind () and rebind () methods of naming class?

808


What are the uses of db2 optimizer?

830


How can you classify the locks in db2?

644


What is the cobol picture clause of the db2 data types date, time, timestamp?

633


How is deadlock resolved?

660


How is a typical db2 batch pgm executed?

652


What is package in db2 mainframe?

565