wht displays the number of times a query modified ?

2 Answers   TCS,

---

What is an instance database?

0 Answers  

---

how to take the back up of the DB2 table.

7 Answers  

---

what is a collection?

2 Answers  

---

What is package in cobol db2?

0 Answers  

---

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

what is difference between Plan and Package

1 Answers   Syntel,

---

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's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

---

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,

---

When can an insert of a new primary key value threaten referential integrity?

2 Answers   Mind Tree,

---