what is the difference between Plan & package
- 3 Answers
- 7533 Views
- IBM, I also Faced
- E-Mail Answers
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 |
What type of SDLC u followed? Why?
How to increase the logical record length of existing PS file?
what is level 66 means??
how to display date in reverse order if the pic clause of the is numeric suppose date is 09032010 ==> need to print in 20100309 (pic clause is numeric)
write a program to eliminate duplicate records in a input file and send them to output file.THIS IS IGATE RECENT QUESTIONN.....JUST 1 WEEK BACKKKK...
wht is the diff b/w if and evaluate stmts ?
after udatingg first 110 rows, my job abends. now how do i change my cobol program so that when i restart the Job it will start updating from 111th row ( i.e in next run I di=ont want to update those 110 rows which are already been updated in the first run before job abend)
In CICS/VSAM every file that is accessed should be defined in FCT. we have CICS READ, WRITE, BROWSE commands for VSAM files. How does it work with DB2 tables. It know it has to do with the plan. Please expain with examples.
Wat is the difference between NEXT and CONTINUE statement in cobol,can any one explain with example.
How arrays can be defined in COBOL?
What is the difference between working storage copybook and linkage section copybook?
Re: 01 NAME1 PIC X(13) VALUE "COBOL PROGRAMMING". 01 NAME2 PIC X(13). now I want to display the value of NAME1 in reverse order i.e value should be displayed as "GNIMMARGORP LOBOC" HOW can I do that ??? please let me know if any one knows it.
COBOL 
