Explain an outer join?

1 Answers  

---

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,

---

What is DCLGEN ?

3 Answers  

---

Explain the use of the WHERE clause.

2 Answers   IBM,

---

Why do we bind in db2?

0 Answers  

---

---

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

---

Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  

---

What is the purpose of rollback and commit?

0 Answers  

---

What is UNION,UNION ALL?

2 Answers  

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

what are extents?

5 Answers  

---