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

how will u retreive value from a table.write it with syntex. 01 ws-table 05 ws-table1 occurs 10 times. 05 ws-table2 occurs 10 times. the above is 2 dimensional array..how will u retrieve 1st element of an array

3 Answers   ADP,

---

Name the sections present in data division.

0 Answers  

---

What is the difference between PIC 9.99 and 9v99 in COBOL?

0 Answers   SwanSoft Technologies,

---

COMP?

2 Answers  

---

wht is packed decimal in cobol

2 Answers  

---

---

Hi Guys, I have faced one interview question if I have requirement to add 5 new columns to existing table what are prerequisite do i need to take.

1 Answers  

---

hi, can you ppl tell me, how to check whether the rewrite we gave for the ksds file is successful or not in the program.? i gave rewrite, the rewrite code is executing and maxcc=0 but updation doenot happen in the file?

1 Answers   CGI,

---

i Want All cobol ERROR codes?

4 Answers   HCL, IBM,

---

how can we get current dat and time thru cobol pgm

3 Answers   DELL,

---

what is meant by binary search?

4 Answers  

---

Name some of the examples of COBOl 11?

0 Answers   CSC,

---

Give some advantages of REDEFINES clause?

2 Answers   Syntel,

---