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 do you mean by rollback?

0 Answers  

---

Explain the function of data manager.

0 Answers  

---

What is reorg in database?

1 Answers  

---

what is the responsibility of the construction superintendent

0 Answers   Almco,

---

How would you print the output of an SQL statement from SPUFI?

2 Answers  

---

---

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,

---

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

0 Answers  

---

What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,

---

Can you search give an array in the WHERE clause of a db2 query?

1 Answers  

---

What is a bind card?

0 Answers  

---