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,

---

What is iseries database?

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,

---

What do you mean by storage group (stogroup)?

0 Answers  

---

how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,

---

What does reorg do in db2?

0 Answers  

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

Can you use max on a char column?

0 Answers  

---

What is the difference between using bind () and rebind () methods of naming class?

0 Answers  

---

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

---

Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  

---