What is a cursor and what is its function?

Answer Posted / s

Cursor is used by DB2 to fetch qualified rows one row at a
time to the application program.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are iseries servers?

569


Why do we bind in db2?

634


What is an instance database?

602


List out the buffer pools in db2

634


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

578






How do you concatenate the firstname and lastname from emp table to give a complete name?

604


What is catalog database in db2?

646


What is drop table?

584


run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

3797


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

579


Outputs of explain are with matchcols = 0. What does this signify?

622


Describe major components of db2?

642


What is the difference between plan and package in db2?

581


Explain the benefits you can get from mainframe connect?

522


How do you select a row using indexes in db2?

647