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


Please Help Members By Posting Answers For Below Questions

What is node in db2?

602


What is the use of db2?

574


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 ?

1703


How connect db2 database to datastage?

753


What types of tables are there in the db2 database?

543






What is meant by explain?

654


Are view updateable?

623


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1698


What is access path in db2?

554


Name the lockable units in DB2?

656


What is ibm db2 client?

512


What is database alias db2?

591


What do you mean by commit and rollback?

586


How do I delete a table in database?

593


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?

2042