Answer Posted / ms. stanley
To create the most optimal path for the SQL Queries in the
program
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
On which levels locks can be applied?
Why do we need reorg in db2?
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 ?...
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
can we view the access paths created by dbrm ? how ? thx
What is the syntax for FETCH in DB2 ?
is it compulsory commitment control in journal?
Can one database have multiple instances?
What is db2 plan table?
What is db2 instance?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Is db2 free?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is ibm db2 client?
what is a corelated subquerry?