Answer Posted / guest
Access path used to give u the best path to access the data
in the DB2 table...
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How does db2 sample database connect?
What r the comman abends in db2, jcl and cobol???????
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is a collection in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Before you give the explain statement, what are the prerogatives?
How do I delete a table in db2?
Where can you declare a cursor in a cobol-db2 program?
What is the default page size of buffer pools?
What is load utility in db2?
What does reorg do in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Explain correlated sub-queries.
What is host variable in db2 cobol?
What is commit in db2?