DB2: A calls B once sucessfull and second time when it
calls says curson is open why is it so?
Answer / sunil
while declearing the cursor in working-storage
section 'with hold' option is used due that's why cursor
remains open while next processing
| Is This Answer Correct ? | 8 Yes | 0 No |
What is query for your birthday date should be in hours,minute and seconds format?
How could one combine a set of incremental image copies into a single copy?
Is it possible to precompile if db2 goes down?
How do we specify index to include or not during bind process.
Define declaration generator (dclgen).
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 ?...
Plan has the optimized access path in it. But is that optimized access path is attained or known
What is db2 isolation?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
Compare a subselect to a join?
What is index cardinality?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?