What else is there in the PLAN apart from the access path?
Answer Posted / s
The Plan contains the executable SQL code(if DBRMs are
directly bound to the plan) with its access path as well as
the consistency token that will be checked against the
contoken in the load module at execution time.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is node in db2?
What is the use of db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How connect db2 database to datastage?
What types of tables are there in the db2 database?
What is meant by explain?
Are view updateable?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is access path in db2?
Name the lockable units in DB2?
What is ibm db2 client?
What is database alias db2?
What do you mean by commit and rollback?
How do I delete a table in database?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?