what is the difference between Plan & package

Answers were Sorted based on User's Feedback



what is the difference between Plan & package..

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

what is the difference between Plan & package..

Answer / krishna chaitanya

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

what is the difference between Plan & package..

Answer / krishna chaitanya

ya i got u Muthaiah

Package is a collection of plans .

Thanks

Is This Answer Correct ?    0 Yes 12 No

Post New Answer

More COBOL Interview Questions

How to remove the spaces at the end of each record in the output file of variable length, via cobol program?

0 Answers  


What are the various section in data division and briefly explain them.

0 Answers  


db2 variable decimal(15,2) what is the equalent size of cobol variable

2 Answers   Syntel,


can anyone explain me the concept of COMP-4 PLEASE??

2 Answers  


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

1 Answers   TCS,






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.

1 Answers  


I have a sequential file. How do I access a record in this sequential file randomly in my program ?

8 Answers   CGI, Xansa,


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?

0 Answers   HeadStrong,


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

13 Answers   TCS,


what happens of we dont give time stamp in precompilation process

2 Answers  


Describe the difference between subscripting and indexing ?

2 Answers  


What is link edit in cobol?

0 Answers  


Categories