Answer / ehsan

It stands for 'System Modification Program Extended' and is a software used by MVS Systems Programmers to manage and install/implement the fixes for large mainframe packages. Eg. for DB2, MVS etc.
The fixes supplied (by IBM) are termed PTFs.

What is meant by dclgen?

0 Answers  

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

what types of copies can be made with the COPY Utility ?

1 Answers  

---

What do you mean by commit and rollback?

0 Answers  

---

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

---

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,

---

define clustering index.

0 Answers  

---

can any one expalin check point with an example?

1 Answers  

---

How can you find out the # of rows updated after an update statement?

0 Answers  

---

Mention the downsides of page level lock.

0 Answers  

---

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---

What is a view? Why use it?

2 Answers  

---