Answer / abhishek kumar

SYSIBM.SYSINDEXES

How do you retrieve the data from a nullable column?

2 Answers  

---

wht displays the number of times a query modified ?

2 Answers   TCS,

---

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

3 Answers  

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  

---

Why cursor is used in db2?

1 Answers  

---

When reorg is used?

1 Answers  

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

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  

---

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

---

What is view db2?

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,

---