Answer / s

Concurrency means that two or more programs that can
peacefully coexist on a tablespace.

what is the input to PLAN? what is the input to DBRM?

4 Answers  

---

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

What are foreign keys in db2?

0 Answers  

---

If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  

---

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

3 Answers   Cap Gemini, Tech Mahindra,

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

What kind of database is db2?

0 Answers  

---

what is cursor stability?

2 Answers   IBM,

---

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,

---