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

Outputs of explain are with matchcols = 0. What does this signify?

1062

Define predicate?

1140

What is catalog database in db2?

1172

What is the use of reorg in db2?

1087

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1087

What is db2 and what is the use of db2 optimizer?

1070

What is a Foreign Key?

1102

How is deadlock resolved?

1152

How to find the number of rows in a db2 table?

1120

What are the benefits of using the db2 database?

1234

Name the lockable units in DB2?

1132

What is reorg?

1164

How do I import data from excel to db2?

1077

What is alias in db2?

1067

How can we retrieve the total number of records in RPG & CLLE?

656