Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

What is RUNSTATS?

3 Answers  

---

can you use symbolic parameters in JOB?

5 Answers   IBM,

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

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 and when does the db2 enforces the unique key?

0 Answers  

---

What is package in cobol db2?

0 Answers  

---

what is plan? is plan executable or package?

4 Answers  

---

How does coalesce work?

0 Answers  

---

What are host variables in db2?

0 Answers  

---