Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to fetch multiple records without using cursor

Answer Posted / premil

It can be done with the help of dynamic sql queries
(prepare,execute).
but i dont remember the syntax...
sorry ...

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1077


What is meant by explain?

1133


What are the prerogatives?

1080


How to rename a table in DB2 ?

1088


How would you find out the total number of rows in a db2 table?

1051


Mention the definition of cobol in varchar field.

1250


What are the various isolation levels possible?

1122


What is view db2?

1076


How do I create a view in db2?

1022


What is the syntax for seeing the columns and data types of a table in the db2 database?

1166


What is drop table?

1010


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1437


How do I add a column to an existing table in db2?

1032


How to restart a DB2 program?

1902


Which isolation level provides highest data integrity?

1117