Answer / obularaju

DBRM- Database Request Modules.

Answer / nishant kumar singh

The DBRM and the SYSIBM.SYSSTMT table of the DB2 catalog.

Is schema the same as database?

0 Answers  

---

in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,

---

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,

---

How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,

---

What is the purpose of the DSNC transaction ?

1 Answers  

---

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

Why do we need reorg in db2?

0 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 common abends

1 Answers   SPIC, Virtusa,

---

What is difference between isnull and coalesce?

0 Answers  

---

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

---

What is the significance of DB2 free space and what parameters control it?

1 Answers  

---