what is the difference between Plan & package
Answers were Sorted based on User's Feedback
Answer / muttaiah
Plan & Package both contains the Optimizer access path for
accessing data from db2 tables. A DBRM(database request
module) can be bind into either plan(Bind plan) or package
(Bind package).
Plan is executable.
Package is not executable.
Plan is a collection of packages.(krishna chaitanya please
correct your answer).
@others: Please do correct me if i'm wrong.
| Is This Answer Correct ? | 13 Yes | 0 No |
Package is a collection of several plans . package is not a
executable form , so we are going to plan for execute the
SQL terms . Plan releases the Timestamp . Plan is a
executable form .
| Is This Answer Correct ? | 3 Yes | 5 No |
ya i got u Muthaiah
Package is a collection of plans .
Thanks
| Is This Answer Correct ? | 0 Yes | 12 No |
How does IDMS communicate with CICS?
What is the LINKAGE SECTION used in COBOL?
COBOL Snippet: Tell where the control will when the below code execute IF (A=B) CONTINUE ELSE NEXT SENTENCE PERFORM <IMP-STMT> END-IF.
Differentiate COBOL and COBOL-II?
What will happen if a variable is declared as below.. Explain with an example? Working storage section:- 01 WS-VARX PIC X(9) VALUE SPACES. 01 WS-VARN REDEFINES WS-VARX PIC 9(9).
01 WS-NAME PIC X(10) OCCURES 2. by this we can get ws-name 2 times. My qustion is how can we access the second name
perform I from 0 by 1 until I=5?How maney times it will executes
How you can characterize tables in cobol?
Why occurs can not be used in 01 level ?
which is faster either static call or dynamic call ? and specify the reasons for it ? reply fast
What will happen if we try to create GDG (+2) generaton instead of (+1) generation?
How do you fetch current date in normal cobol pgm and in cobol-db2 pgm?