In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

What are iseries servers?

0 Answers  

---

What are the three DB2 date and time data types and their associated functions?

1 Answers  

---

How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  

---

---

what is the use of cursors?

3 Answers   iGate,

---

What is pagespace?

1 Answers  

---

What is DCLGEN?

2 Answers  

---

What is cursor stability in db2?

0 Answers  

---

What is null indicator in db2?

0 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---