Answer / s

DB2 Precomplier comments out the SQL statments and replaces
with CALL statements to DB2. It places the consistency
token in both the DBRM and modified source program.

Answer / gouri

dsnhpc

What is a page?

2 Answers  

---

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  

---

What is catalog database in db2?

0 Answers  

---

How does DB2 store NULL physically?

2 Answers  

---

What is cursor stability in db2?

0 Answers  

---

What is the use of runstats in db2?

0 Answers  

---

Give some example of statistics collected during RUNSTATS?

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

---

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  

---

Mention some fields that are a part of sqlca.

0 Answers  

---

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

---

My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

---