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

consider the following two statements MOVE 10 TO N PERFORM PARA-X N TIMES STOP RUN PARA-X MOVE 5 TO N how many times PARA-X willbe exicuted? a.10 b.5 c.infinate d.execution error

6 Answers   ABCL, TCS,

---

which of the following can be used as a check protection symbol a.Z b.S c.* d.+

2 Answers   TCS,

---

What is the default value(s) for an initialize and what keyword allows for an override of the default?

0 Answers  

---

How many types of sorts are there in cobol?

5 Answers   Cap Gemini,

---

how do you reference the printer file formats from cobol programs

0 Answers  

---

When search all is used in cobol program without sorted input data?

6 Answers   CGI, Principal Finance,

---

How can i write a comp-3 variable into a sequential file should i declara the field in the file description as comp- 3?

1 Answers  

---

how can i see junk values in dclgen or in hostvariable of comp ?

0 Answers   DELL,

---

What is the difference between write & move in COBOL?

3 Answers   CSC, HHB,

---

Minimum how many Number of Paragraphs are there in ID- Divison?

7 Answers   IBM,

---

hi friends,can any one post the ibm mainframe inteqview questions for 1year exp candidate,for itc infotech interview?. have any body attended for this in the past?...

1 Answers   ITC Infotech,

---

can i use multiple when statements in search & search all ? justify ur answer?

2 Answers  

---