When is the results table for the query in a DECLARE CURSOR
statement created?
Answer Posted / mani
the first one is correct i.e. when the open cursor statement
gets executed, the results table is created for the query in
declare cursor statement.
after that when fetch is done it is actually retrieved one
by one from the results table.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Why do we use cursor?
How does cobol compile db2 program?
What is the information associated with sysibm.syslinks table?
What kind of database is db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is data manager?
What is a db2 tablespace?
What is check constraint. Explain with example.
How to create backup table in db2?
Explain the function done by data manager?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is view db2?
Explain the contents that are a part of dclgen.
How many databases can be created inside an instance in db2 ?
Explain about open switch business continuity software?