have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  

---

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

---

What is a SELECT statement?

1 Answers  

---

What will the DB2 optimizer do?

2 Answers  

---

What is deadlock in db2?

0 Answers  

---

What is host variable in db2 cobol?

0 Answers  

---

What is db2 isolation?

2 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,

---

Can you search give an array in the WHERE clause of a db2 query?

1 Answers  

---

What are the various isolation levels possible?

0 Answers  

---

What is referential integrity?

5 Answers  

---

What are the isolation levels possible ?

3 Answers  

---