Answer / s

You can use LOCK TABLE on any table. View is not a
physical object.

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers  

---

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers   TCS,

---

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---

what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,

---

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,

---

Can any one tell me about Restart logic in DB2.

2 Answers  

---

What is a clustering index?

2 Answers  

---

What is meant by union and union all?

0 Answers  

---

What is null indicator in cobol db2?

0 Answers  

---

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

---

How do we specify index to include or not during bind process.

0 Answers   Satyam,

---

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

---