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 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,

---

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  

---

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

---

what is the use of bind parameter, Replace?

5 Answers   IBM,

---

What is a host variable?

3 Answers  

---

What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,

---

difference between group clause and order clause

1 Answers  

---

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  

---

What is deadlock in db2?

0 Answers  

---

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

---

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

---