When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,

---

How to compare data between two tables in db2?

0 Answers  

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

---

What is null value in db2?

0 Answers  

---

What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  

---

How can you display the current date & current time ?

1 Answers   Cap Gemini,

---

what is diffrence b/w file-aid tool and file-aid utility???

1 Answers  

---

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

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

1 Answers  

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---