OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

---

where will u check for sqlcode ?

2 Answers   TCS,

---

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers  

---

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

---

What is meant by AUTO COMMIT?

3 Answers  

---

What is precompiler in db2?

0 Answers  

---

How can you display the current date & current time ?

1 Answers   Cap Gemini,

---

When reorg is used?

0 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

What is the self-referencing constraint?

2 Answers  

---

What is the reason behind not using select * in embedded sql programs?

0 Answers  

---