What is the difference between a package and a plan?
Answer Posted / krishna priya
plan contains multiple DBRMs.but packag contains single
DBRMs as well as when package will excuated include the
list of plans
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What is db2 purescale?
How does db2 sample database connect?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the usage of open cursor command?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is db2 plan table?
List down the data types in the db2 database.
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is dbrm?
What is node in db2?
What is the maximum length of sqlca?
What is clone table?
What is cascading rollback?
Give a brief description of db2 isolation levels?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference