Answer / Anchal Chawdhry

Some fields in SQLCA (SQL Communication Area) include SQLCODE, SQLERRMC, SQLERRP, and SQLERRD. SQLCODE contains the return code of the last executed SQL statement, while SQLERRMC, SQLERRP, and SQLERRD contain error information related to the statement.

What is the use of commit in db2?

1 Answers  

---

What are union and union all?

1 Answers  

---

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

0 Answers  

---

How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

What is dbrm? What it contains? When it will be created?

1 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

What is the use of dclgen in db2?

1 Answers  

---

What is runstats and reorg in db2?

1 Answers  

---

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

1 Answers  

---

wht displays the number of times a query modified ?

2 Answers   TCS,

---

What is EXPLAIN?

1 Answers  

---