Answer / s

The Plan contains the executable SQL code(if DBRMs are
directly bound to the plan) with its access path as well as
the consistency token that will be checked against the
contoken in the load module at execution time.

why we go for SPUFI for creating tables or for sql queries?

4 Answers  

---

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  

---

What is role in db2?

0 Answers  

---

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,

---

What is a lock?

1 Answers  

---

---

How is the value function used?

0 Answers  

---

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  

---

How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,

---

wht displays the number of times a query modified ?

2 Answers   TCS,

---

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,

---

what is dynamic cursor?gives syntax for this?

1 Answers   TCS,

---

What are the advantages of using a PACKAGE?

2 Answers  

---