What is a DB2 plan?

Answer Posted / anil

A plan provides the channel between the aplication program
and the system which can be called up on call statements to
cobol for the sql code from db2 catalog when bind process
has done..

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

903


What is meant by union and union all?

783


What is drop table?

776


What is nvl in db2?

822


Define db2 and its databases?

815


what is a corelated subquerry?

834


What is cascading rollback?

857


What are types of indexes?

773


Explain the function done by data manager?

1035


What is node in db2?

811


What is a plan and package in db2?

843


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

850


How is the value function used?

835


What is host variable?

807


Outputs of explain are with matchcols = 0. What does this signify?

834