None of the host languages can handle multiple records at a time. But i

how to fetch multiple records without using cursor

Question Posted / sivakumar sekharannair

14 Answers
39061 Views
HCL, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Can we insert update delete in view?

918

What is database alias db2?

1071

What is alias in db2?

999

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1058

What is dpf in db2?

1062

What is db2 optimizer?

1190

What are db2 tables?

1067

What is page size in db2?

917

What is role in db2?

1052

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3154

How to retrieve rows from a db2 table in embedded sql?

1345

How can deadlocks be resolved?

899

What is a cursor in programming?

1024

What is the difference between cursor stability and repeatable read isolation levels?

1128

What is the function of logging in the db2 database?

1079