Answer / s

DSNDB07 database is a work file database and is used by SQL
statements that require working storage like sorts.

Answer / kums

DSNDB07 may be used to perform sorting(order by clause).

What else is there in the PLAN apart from the access path?

1 Answers  

---

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,

---

What are some characteristics of columns that benefit from indexes?

1 Answers  

---

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

2 Answers   CTS,

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

How does DB2 use multiple table indexes?

1 Answers  

---

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---

How can deadlocks be resolved?

0 Answers  

---

What is a root page?

1 Answers  

---

Explain the function of data manager.

0 Answers  

---

what is rebinding ?

1 Answers   IBM,

---

What is the purpose of the WHENEVER statement?

1 Answers  

---