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.

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 .

Answer / krishna chaitanya

ya i got u Muthaiah

Package is a collection of plans .

Thanks

Give some advantages of REDEFINES clause?

2 Answers   Syntel,

---

DATAONLY, MAPONLY functionality?

1 Answers   IBM,

---

We are using the searching a table which is indexed, once the key is found, how can we get the occurance at which the key was found.

1 Answers  

---

I want to declare a field with data type Double in my COBOL program. how shall i do that ?

5 Answers  

---

what are the working storage fields in BMS macro?

2 Answers   IBM,

---

what is label record is standard or omitted in file description of data division?

3 Answers   IBM, TCS,

---

How to fetch 1000 error records from VSAM file(Eg: 1000000 records present) while getting SOC7 abend ?

0 Answers  

---

how to pass 100 to s9(4) how r they inserted ?

3 Answers   TCS,

---

Can the OCCURS clause be at the 01 level?

2 Answers  

---

Which mode is used to operate the sequential file?

0 Answers  

---

what is search and searchall?what is the diffrence between them?give an best example?

3 Answers   BirlaSoft,

---

i WANT ALL ERROR codes IN CICS and DB2

2 Answers  

---