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 the use of db2 optimizer?

0 Answers  

---

What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,

---

How do we specify index to include or not during bind process.

0 Answers   Satyam,

---

how to take the back up of the DB2 table.

7 Answers  

---

---

What is UNION,UNION ALL?

2 Answers  

---

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

---

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

---

What are the functions in DB2?

3 Answers   Satyam,

---

Highlight all the advantages that are attached to a package.

0 Answers  

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers  

---

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 Answers  

---