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

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2023


How does db2 sample database connect?

792


Give a brief description of db2 isolation levels?

802


What is cascading rollback?

868


What is dbrm? What it contains? When it will be created?

808


What is a cursor in programming?

836


What is the picture clause of null indicator variable?

906


What is difference between isnull and coalesce?

822


What is a db2 collection?

814


What is explain plan in db2?

792


What is the difference between bind and rebind in db2?

1203


How does cobol compile db2 program?

825


what is utility for parm lib

2112


What is phantom read in db2?

847


How do we specify index to include or not during bind process.

1875