how to fetch multiple records without using cursor

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


Please Help Members By Posting Answers For Below Questions

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

690


What are types of indexes?

580


What action db2 takes when a program aborts in the middle of a transaction?

646


How does coalesce work?

574


Which command is used to remove all rows from a table?

543






What is the use of dclgen in db2?

579


How can you classify the locks in db2?

624


B37 abend during spufi?

970


Explain about open switch business continuity software?

552


What is the latest version of ibm db2?

727


What is clone table?

587


How to execute stored procedures?

612


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

736


What are the rules for db2 programming?

634


What are bind parameters in db2?

605