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

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

Question Posted / mehdee

Answer Posted / mehdee

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to find the number of rows in db2 tables?

1127

What is the result of open cursor statement?

1126

what is utility for parm lib

2418

What is the difference between drop table and delete table?

1285

What is the role of union all and union

1186

What is db2 stogroup?

1220

i want to maintain uniqueness on pdf without make lf??????????

2204

What is db2 optimizer?

1309

What parameters are used to control the free space in DB2?

1094

How would you find out the total number of rows in a db2 table?

1094

What is nvl in db2?

1147

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1244

What is db2 catalog database?

1088

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1220

How does cobol compile db2 program?

1128