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 |
What are VS COBOL 11 special features?
BY seeing a program how can we say that it is static call or dynamic call
What is R-mode and A-mode?
How can we find out wether to declare the data items like Integer, Char,Comp? If comp types how can we decide wether it is Comp and Comp3.How it is? Please Explain... Cheers.
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...
I have a program with an Array of 5000 occurences which is being passed from 5 sub levels to the front end screen. Thess 5 programs using each 5*2 = 10 different arrays with size as 5000. This is causing the transaction to utilize more storage consupmtion. I am looking to reduce the storage consumption. As part of that initially i thought Dynamic array may solve my problem. After viewing the comments given i see its same as normal array. IS there any other way we can resolve this issue?
tell me about examine inspect and evaluate ?
What does EXIT do ?
I have the file which is having the extension no as records. sample file will look like below. 2310 3410 3256 4350 3781 5408 I need to replace the record which is starting with 3 to 5 (i.e) 3410 to 5410. How can we do it through cobol and cobol-db2 program? I need the possible logic?
If a file has 1000 records.. if i have to replace the first and last characters of the file with another character. how it can be done....
waht is inspect verb? where it can be in real time?
what do you mean by copybook? and what is the difference between the copybook which we are using in working storage and procedure division.