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

What is role in db2?

608


What is explain in db2?

578


How do you pull up a query which was previously saved in qmf?

661


What are the various isolation levels possible?

638


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

603






define clustering index.

612


What is meant by explain?

654


What is cursor stability in db2?

796


Where can you declare a cursor in a cobol-db2 program?

598


How is the value function used?

595


How can you find out the # of rows updated after an update statement?

631


What is db2 connect?

594


When the like statement is used?

627


Define data page.

624


Highlight all the advantages that are attached to a package.

619