Answer / vaneesh khurana

1.compile and run the program,in the spool we can find the
offset value for the job. note that offset value and run
the same job again with compiler option as LIST.
2.see the spool for the offset value where it is
located,means exactly in which numerical operation that
abbend occured.EG: total = salary + commision.

What is alias in db2?

0 Answers  

---

what is the use of cursors?

3 Answers   iGate,

---

What is a Database Request Module(DBRM)?

4 Answers  

---

What is reorg?

0 Answers  

---

What is scrollable cursor in db2?

0 Answers  

---

how to check the table is empty or not?

3 Answers   IBM,

---

What is a subselect? Is it different from a nested select?

1 Answers  

---

What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,

---

How to find the number of rows in db2 tables?

0 Answers  

---

How would you find out the total number of rows in a db2 table?

0 Answers  

---

What is EXPLAIN?

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,

---