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 |
Explain the configuration section of a cobol program with examples of syntax.
Hi , I am posting some questons which are asked at interview. These may help u for ur interview... what is static and dynamic call?
how do you reference the variable unblock file formats from cobol programs
Which is not true about evaluate statement
Why would you use find and get rather than to obtain?
We are using the searching a table which is indexed, once the key is found, how can we get the occurance at which the key was found.
) How do you access the migrate the data from production region to development region
WHY LRECL NEEDS TO BE 4 EXTRA THEN THE COBOL FILE LENGTH & WHAT IT CONTAIN IN THAT LENGTH
Scenario: I have 3 Input Files.Read the first i/p file and depending on certain business logic, I want to read wither i/p file-2 or i/p file-3.Now, depending on certain business logic applied to the record read from either file-2 or file-3, I decide to write them to either output file-2 or output file-2. Question: How many job steps are necessary to implement a solution for the above.
what are the limitations of Inline Perform?
What are INPUT PROCEDURE and OUTPUT PROCEDURE?
what is jcl approach for programming?