Answer / sunil1405

join is more efficeint, Subselect can be written as a join.

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

What does the CHECK Utility do ?

1 Answers  

---

what is the difference between join and union?

4 Answers   IBM,

---

Explain the benefits you can get from mainframe connect?

0 Answers  

---

What is a synonym? How is it used?

2 Answers  

---

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,

---

in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,

---

How to design maps

1 Answers   Virtusa,

---

What are the full forms of spufi and dclgen and why are they used?

0 Answers  

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,

---

What are iseries servers?

0 Answers  

---

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

---