Answer / harsha

Working-Storage Section.
01 WS-FIELD.
49 WS-FIELD-TEXT PIC X(40).
49 WS-FIELD-LEN PIC S9(4) COMP.

PROCEDURE DIVISION.

MOVE +45 TO WS-FIELD-LEN.
MOVE 'UPDATE TAB1
SET ----=:----- WHERE ---=:----'
TO WS-FIELD-TEXT.
EXEC-SQL
EXECUTE IMMEDIATE:WS-FIELD
END-EXEC.

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,

---

What does the sqlcode of -818 pertain to?

3 Answers  

---

How can deadlocks be resolved?

0 Answers  

---

Explain the function of data manager.

0 Answers  

---

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

---

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

---

Explain the benefits you can get from mainframe connect?

0 Answers  

---

Give the COBOL definition of a VARCHAR field.

2 Answers  

---

what is load and unload in db2

1 Answers   IBM,

---

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  

---

Explain the contention situations caused by locks?

0 Answers  

---

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

---