how to fetch multiple records without using cursor
Answer Posted / sivakumar sekharannair
None of the host languages can handle multiple records at a
time.
But i think if we know the number of rows that will be
retreived then we can load the records into a internal
table and then process it as required...
Any thoughts!!!!!!
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is consistency token in db2?
what is a corelated subquerry?
What are foreign keys in db2?
What do you mean by cursor?
What is a Foreign Key?
What is dclgen in db2?
What is node in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What are union and union all?
What is cursor stability in db2?
Is db2 a programming language?
What is alias in db2?
What does db2 plan contain?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
what is the responsibility of the construction superintendent