Answer / shyam

In the Plans or packages which has the Static SQL's,
Authorization check is done based on the VALIDATE parameter
in BIND control card ..If VALIDATE(BIND), Authorization
check is done during the BIND time. If VALIDATE(RUN),
Authorization check is done during the run time.

For the plans or packages having Dynamic SQL's ,
Authorization check is done during the run time.

Shyam

How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  

---

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---

Mention the various locks that are available in db2.

0 Answers  

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

wht is d/f between union and joins ?

2 Answers  

---

---

What is Declaration Generator(DCLGEN)?

1 Answers  

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---

What is the usage of open cursor command?

0 Answers  

---

What is a correlated sub query?

2 Answers  

---

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,

---

What is the difference between group by and order by?

2 Answers   IBM, TCS,

---

If I have a view which is a join of two or more tables, can this view be updateable?

0 Answers  

---