what is difference between Plan and Package

Question Posted / guest

1 Answers
6221 Views
Syntel, I also Faced
E-Mail Answers

what is difference between Plan and Package..

Answer / swapnil

PLAN IS A EXECUTABLE CODE FOR COBOL.
PLAN IS A COLLECTION OF PACKAGE AND IT IS OUTPUT OF
BIND PROCESS.

PACKAGE: PACKAGE CONTAIN ONE DB REQUSET MODULE(DBRM)
AND IT IS NOT EXECUTABLE MODULE.

Is This Answer Correct ?

12 Yes

2 No

Post New Answer

More DB2 Interview Questions

What do you mean by cursor?

0 Answers

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers Cap Gemini,

How do I copy a table in db2?

0 Answers

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers

What is a DB2 bind?

3 Answers

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers

What is db2 purescale?

0 Answers

List out the data types available.

0 Answers

What is the physical storage length of date data type?

0 Answers

What does the sqlcode of -818 pertain to?