When is the results table for the query in a DECLARE CURSOR
statement created?
- 5 Answers
- 7462 Views
- I also Faced
- E-Mail Answers
Answer Posted / biswamoy
You can Declare Cursor either in Working-storage section or
in Procedure division. It is not executable
OPEN CURSOR is executable ( here it creates Result), Fetch
rows within loop then close cursor.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to compare data between two tables in db2?
What do you mean by cursor?
When reorg is used?
What r the comman abends in db2, jcl and cobol???????
What are db2 tables?
What is blu acceleration in db2?
What is the maximum number of columns in a db2 table?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Which isolation level provides maximum concurrency?
What is a trigger in the db2 database?
What is declare cursor?
How do I delete a table in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
Name the various locking levels available?
How does a cursor work?
