Answer / shweta agarwal

access path can be viewed by specifying the EXPLAIN
Parameter in the bind JCL as YES..
synatx

EXPLAIN(YES).

Answer / krishna

I think not possible. information about
access path stored in database catalog.
access path is stored in DB DIRECTORY, it can be used by
DB2 internally. no one can access the dB2 directory



if wrong please post right answer

What can the Locate option of the Repair Utility accomplish?

2 Answers  

---

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

How to execute stored procedures?

0 Answers  

---

What is commit in db2?

0 Answers  

---

What is cursor in dbms?

0 Answers  

---

What is cursor stability?

1 Answers  

---

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

---

i want to delete 20th million record how ?

4 Answers   IBM,

---

What is multi row fetch in db2?

0 Answers  

---

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,

---

Are views updatable ?

4 Answers  

---