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


What is a cursor?

Answers were Sorted based on User's Feedback



What is a cursor?..

Answer / guest

A cursor is a programming device that is used to handle the
rows that are returned by the query as the host language
(cobol) can handle only one row at a time. its also a small
file that has the result set. The cursor has to be
declared,opened, fetched and closed to access the data
returnee by the query.

Is This Answer Correct ?    2 Yes 0 No

What is a cursor?..

Answer / vinod babu bachina

In DB2 cursor is used to fetch more than one row from a DB2
table. But cursor can fetch only one row at a time. Suppose
if ur retrieving more than one row from table , u have to
use cursor only. If u use SELECT instead of cursor then it
leads to error '' more than one row selected in select'.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  


How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  


WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,


How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,


What's The Error Code For Unique Index Voilation?

0 Answers   IBM,


how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers   IBM,


What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,


What are the functions in DB2?

3 Answers   Satyam,


how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,


How to find the number of rows in a db2 table?

0 Answers  


pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,


Categories