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.

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

---

What is image copy?

1 Answers   Virtusa,

---

How can you display the current date & current time ?

7 Answers   Cap Gemini,

---

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

---

What is the difference between plan and package in db2?

0 Answers  

---

---

What is db2? Explain.

0 Answers  

---

define clustering index.

0 Answers  

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

---

wht displays the number of times a query modified ?

2 Answers   TCS,

---

what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  

---

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

---