which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

Mention some fields that are a part of sqlca.

0 Answers  

---

What is the purpose of using commit?

0 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 check constraint. Explain with example.

0 Answers  

---

What is difference between rollback and commit?

0 Answers  

---

How do I optimize a query in db2?

0 Answers  

---

What is the purpose of the DSNC transaction ?

1 Answers  

---

What is an inner join, and an outer join ?

1 Answers   CTA,

---

What is SPUFI?

4 Answers  

---