Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  

---

What is the STOSPACE Utility used for?

1 Answers  

---

Can we insert update delete in view?

0 Answers  

---

What is difference between alias and synonym in db2?

0 Answers  

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

What is package in cobol db2?

0 Answers  

---

How do you select a row using indexes in db2?

0 Answers  

---

What is null in db2?

0 Answers  

---

Mention the downsides of page level lock.

0 Answers  

---

What is explain in db2?

0 Answers  

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---