Explain correlated sub-queries.

0 Answers  

---

Explain the contents that are a part of dclgen.

0 Answers  

---

What is a collection in db2?

0 Answers  

---

What is DCLGEN?

2 Answers  

---

What does the RUNSTATS Utility do?

4 Answers  

---

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

---

What is a buffer in memory?

0 Answers  

---

Can we install 2 different versions of Db2 on same mainframe?

3 Answers  

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

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's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,

---