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...

When is the results table for the query in a DECLARE CURSOR
statement created?

Answer Posted / mani

the first one is correct i.e. when the open cursor statement
gets executed, the results table is created for the query in
declare cursor statement.

after that when fetch is done it is actually retrieved one
by one from the results table.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is consistency token in db2?

1191


What is a db2 collection?

1106


What is drop table?

1064


Why select is not preferred in embedded sql programs?

1346


What are catalog tables in db2?

1104


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

1288


What is db2 bind process?

1288


What is buffer pool in the db2 database?

1153


What is bufferpool in db2?

1095


What language is db2 written in?

1101


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

1094


What is a bind card?

1276


What is access path in db2?

1042


What is the connection string to connect to the DB2 Database ?

1171


What db2 400?

1250