how to check the table is empty or not?

3 Answers   IBM,

---

What is a storage group (stogroup)?

0 Answers  

---

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,

---

What are the various data types available in db2?

0 Answers  

---

What is dbrm? What it contains?

0 Answers  

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---

How many clustering indexes can be defined for a table?

2 Answers  

---

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---

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,

---

How can we retrieve the total number of records in RPG & CLLE?

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 is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

---