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?

Answer Posted / harsha

I feel yes, we can fetch the same cursor in the same
program.
Cursor can be closed in three ways.
1 When you explicitely close trhe cursor.
2 Issuing commit systement.
3 After execution of an application program.

In our situation, none of the above mentioned case is
getting true.

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are db2 tables?

647


How do you select a row using indexes in db2?

645


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

628


What are iseries servers?

566


What is the role of data manager in the db2 database?

645






What is null indicator in cobol db2?

585


Is db2 a database?

574


What is alias in db2?

568


What are host variables in db2?

625


What is dbrm? When it will be created?

598


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

3790


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

1595


What is db2 stogroup?

674


How to create db2 table in mainframe?

629


What do you mean by between and in? Is between inclusive of specified range values?

667