how to fetch multiple records without using cursor
Answer Posted / anto
The question is to fetch multiple records...not multiple
row(s)..
So this is possible with single select query.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How does a cursor work?
What are catalog tables in db2?
Why do chiropractors use drop table?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is a db2 collection?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Is db2 a mainframe?
Mention the downsides of page level lock.
What are iseries servers?
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
Is db2 a programming language?
what is utility for parm lib
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Is the primary key a clustered index?
How to find the number of rows in a db2 table?