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

Why do we use cursor?

1084


How does cobol compile db2 program?

1034


What is the information associated with sysibm.syslinks table?

1106


What kind of database is db2?

1021


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2827


What is data manager?

1026


What is a db2 tablespace?

1044


What is check constraint. Explain with example.

1081


How to create backup table in db2?

1067


Explain the function done by data manager?

1257


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2040


What is view db2?

1047


Explain the contents that are a part of dclgen.

1071


How many databases can be created inside an instance in db2 ?

1011


Explain about open switch business continuity software?

1111