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.

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

Update command

1 Answers  

---

Comment whether the cursor is closed during commit or not.

0 Answers  

---

what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

---

What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  

---

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

---

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

1 Answers  

---

What is sqlca’s maximum length?

0 Answers  

---

Which component is responsible for db2 startup and shutdown?

0 Answers  

---

wht are the restrictions for union ?

2 Answers   CTS,

---