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

What is host variable in db2 cobol?

1028

What is collection in db2 bind?

961

What are the different types of base tables?

1027

Explain in brief how does db2 determine what lock-size to use?

959

What is buffer pool in the db2 database?

1046

What is the information associated with sysibm.syslinks table?

1056

What is check constraint. Explain with example.

1044

What is null value in db2?

950

What are the uses of db2 optimizer?

1223

Is db2 a mainframe database?

943

What is node in db2?

986

List down the data types in the db2 database.

1041

What does a deadlock mean in DB2?

1095

Explain how can you do the explain of a dynamic sql statement?

1063

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114