how to fetch multiple records without using cursor
- 14 Answers
- 35014 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / chakradhar patra
Yes its possible in NATURAL using MULTI-FETCH Option.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why do we need reorg in db2?
What is cursor with hold option in db2?
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 clone table?
What is the difference between cursor stability and repeatable read isolation levels?
What is the connection string to connect to the DB2 Database ?
What is coalesce in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Explain packages.
What is release/acquire in bind?
How to view db2 table structure?
Explain in brief how does db2 determine what lock-size to use?
How connect db2 database to datastage?
Explain what are the various isolation levels possible?
What is host variable in db2 cobol?
