Answer / ms. stanley

DCLGEN, as it is called, Contains the table Description and
the Field Names for the program to access the DB2 table

Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

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 does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

Can you use max on a char column?

0 Answers  

---

Which transaction use a command thread ?

1 Answers  

---

How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  

---

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

4 Answers   IBM,

---

What is the difference between spufi and qmf?

0 Answers  

---

what is the soft code for deadlock ?

2 Answers   Logica CMG,

---

How do I add a column to a table in db2?

0 Answers  

---

how 2 resolve the -311 sqlcode

1 Answers  

---