When is the results table for the query in a DECLARE CURSOR
statement created?
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
Define sqlca.
What is database alias db2?
Explain dclgen.
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
When the like statement is used?
What is ibm db2 used for?
What is db2 plan table?
How does a cursor work?
What is the connection string to connect to the DB2 Database ?
How to compare data between two tables in db2?
What happens in bind step in a db2 program?
Are view updateable?
What is rct?
How to find primary key of a table in db2?
Explain about open switch business continuity software?