Answer / islam

-1 indicates that the field contain a NULL value
0 indicates that the field contain valid value
-2 indicates that the field the field contain junk value
due to data conversion error

How will you delete duplicate records from a table?

7 Answers   Google,

---

Why do we bind in db2?

0 Answers  

---

What is subquery ?

6 Answers  

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

What is copy pending status in db2?

0 Answers  

---

---

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

---

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

2 Answers  

---

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

0 Answers   IBM,

---

Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,

---

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

---

What is db2 isolation?

2 Answers  

---

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

---