Answer / s

The optimizer will determine all the different access paths
for the query and does a cost-based analysis and chooses
the the least expensive path.

Answer / srinivas yadav

OPTIMIZER: IT CHOOSES THE BEST ACCESS PATH.

What is meant by AUTO COMMIT?

3 Answers  

---

is there any restrictions for unions ?

4 Answers   Patni,

---

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers   IBM,

---

How could one combine a set of incremental image copies into a single copy?

1 Answers  

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

---

Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,

---

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

What is read-only cursor?

1 Answers  

---

What is check constraint in db2?

0 Answers  

---

What is the role of union all and union

0 Answers  

---

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  

---