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 to remove the spaces at the end of each record in the output file of variable length, via cobol program?
What are the various section in data division and briefly explain them.
db2 variable decimal(15,2) what is the equalent size of cobol variable
can anyone explain me the concept of COMP-4 PLEASE??
consider the following FD FILE-1 01 REC-1 PIC X(80) ...... WORKING-STORAGE SECTION 01 W-REC PIC X(90) ........ PROCEDURE DIVISION FIRST-PARA ....... READ FILE-1 INTO W-REC AT END MOVE 1 TO EOF-FLAG which of the following is true with respect to the above? a.REC-1 will contain nothing and W-REC will contain the contains of the record read b.REC-1 and W-REC contain the same data c.syntex is invalid and error will occur d.REC-1 and W-REC must be of same size
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.
I have a sequential file. How do I access a record in this sequential file randomly in my program ?
How can i load all the data from a file to Table (array) in cobol.How i manage the occurs clause with out reading the file.Any options avilable ? Please can any one help me it is urgent?
OCCURS clause is used in the DATA DIVISION on data names at (a) 01 level (b) 77 level (c) 88 level (d) any level from 02 to 49
what happens of we dont give time stamp in precompilation process
Describe the difference between subscripting and indexing ?
What is link edit in cobol?