Interested to Buy Any Domain ? << Click Here >> for more details...
what is plan?
is plan executable or package?
- 4 Answers
- 11415 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harsha
paln is nothing but collection of packages
paln is executable where package is non-executable
| Is This Answer Correct ? | 14 Yes | 3 No |
Answer / tej
A small correction for Harsha's answer
Plan can also contain DBRMs along with collections of packages.
and Yes,Plan is executable where as package is not.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / nidhi
Plan and packages both are executable.
Package is the executable form of single DBRM while
multiple pacages or DBRM can be bind together through the
same plan.
| Is This Answer Correct ? | 2 Yes | 10 No |
Answer / hatam
A package contains control structures used to execute SQL
statements
A plan is
1- A list of package names
2- The bound form of SQL statements taken from one or more
DBRMs
package is executable and plan not
| Is This Answer Correct ? | 0 Yes | 19 No |
The only place of VSAM KSDS in DB2 is?
Mention the various locks that are available in db2.
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is the difference between cursor stability and repeatable read isolation levels?
What are the advantages of using a PACKAGE?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What does db2 plan contain?
how can we retrieve the 100 records of the file ?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
Is there any advantage to denormalizing DB2 tables?
What is phantom read in db2?
What's The Error Code For Unique Index Voilation?
COBOL 
