When you open the cursor the result set is built.

when does the SQL statement gets executed when you use
cursor in the application programming ?

Question Posted / s

Answer Posted / s

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is multi row fetch in db2?

1052

Can there be more than one cursor open for any program?

1169

When do you specify the isolation level?

1034

What is the difference between cursor stability and repeatable read isolation levels?

1178

What is the use of commit in db2?

1083

How do I start db2 in windows?

1096

How does a cursor work?

993

How to access db2 tables in mainframe?

1055

Mention the different locking levels that are available in db2.

1138

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

1055

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

1126

How to find the maximum value in a column in the db2 database?

1084

Is the primary key a clustered index?

1149

What is check constraint. Explain with example.

1109

What is an instance database?

1054