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,

---

Why do we use cursor?

0 Answers  

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

What is cursor stability?

1 Answers  

---

what is db2 restart?

0 Answers  

---

Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers   MCN Solutions,

---

What is the maximum size of a char data type in db2?

0 Answers  

---

Is schema the same as database?

0 Answers  

---

What will happen, while trying to close the closed cursor.

1 Answers  

---

What is correlated subquery?

1 Answers  

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---

What is clone table?

0 Answers  

---