how to fetch multiple records without using cursor

Answer Posted / rajni

U cant fatch the record without using cursor.

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a corelated subquerry?

660


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

659


What is bind and rebind in db2?

652


Where can you declare a cursor in a cobol-db2 program?

604


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

714






What is runstats utility in db2?

569


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.

2757


What is the reason behind not using select * in embedded sql programs?

603


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.

2324


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

660


Explain the function of data manager.

632


What is netezza database?

573


B37 abend during spufi?

982


Is db2 a mainframe?

589


How do I change the column size in db2?

593