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
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is meant by union and union all?
What is drop table?
What is nvl in db2?
Define db2 and its databases?
what is a corelated subquerry?
What is cascading rollback?
What are types of indexes?
Explain the function done by data manager?
What is node in db2?
What is a plan and package in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How is the value function used?
What is host variable?
Outputs of explain are with matchcols = 0. What does this signify?