My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,

---

How can you compare table column after update and before update?

5 Answers   Satyam,

---

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  

---

Mention the location where the output received from explain statement is stored.

0 Answers  

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---

What are some characteristics of columns that benefit from indexes?

1 Answers  

---

What is meant by dclgen?

0 Answers  

---

What action db2 takes when a program aborts in the middle of a transaction?

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 a db2 table?

0 Answers  

---

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

---

select 100 records from million records ?

2 Answers   Verizon,

---