When OPEN CURSOR is executed

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

Question Posted / s

Answer Posted / s

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What does runstats do in db2?

1117

What is dbrm?

1105

What is the difference between drop table and delete table?

1208

What is commit in db2?

1055

Can you tell me how can you find out the # of rows updated after an update statement?

1101

How is the value function used?

1154

what is db2 restart?

2158

What is phantom read in db2?

1157

What is the picture clause of null indicator variable?

1138

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1065

Why db2 is called db2?

1039

Explain about mirror activator disk mirroring?

1009

Mention the location where the output received from explain statement is stored.

1127

What is sqlca?

1074

What is the advantage in De-normalizing tables in DB2?

1175