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).

How is the value function used?

0 Answers  

---

What is usage pointer in cobol?

3 Answers   IBM,

---

How to execute stored procedure in db2 command editor?

0 Answers  

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

What is the difference between CS and RR isolation levels?

1 Answers  

---

How does one remove entries from the SCT02 table?

1 Answers  

---

Name some fields from SQLCA

1 Answers  

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,

---

What is correlated subquery?

1 Answers  

---

What is null indicator in db2?

0 Answers  

---

What is deadlock?

2 Answers  

---