Answer / nidhi sharma

joining of data from two different table by coloums
inner join
outer join
a.left outer join
b.right outer join
c.full outer join

Answer / vamsikrishnamraju

Sometimes we have to select data from two or more tables to
make our result complete.
inner join
left join
right join

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

---

what is the difference between join and union?

4 Answers   IBM,

---

If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,

---

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

---

What is dynamic SQL?

1 Answers   ADP,

---

What are the three types of page locks that can be held?

1 Answers  

---

How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,

---

What is cursor stability?

1 Answers  

---

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

---

how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers   IBM,

---

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,

---

Explain what are the various isolation levels possible?

0 Answers  

---