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.

What does CURRENTDATA option in bind indicate

1 Answers   IBM,

---

quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  

---

what is difference between random and sequence file access

1 Answers   Syntel,

---

What are the functions of Bind?

2 Answers   Amdocs, IBM,

---

What is db2 purescale?

0 Answers  

---

---

max number of columns in a db2 table?

6 Answers  

---

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

---

What is bind and rebind in db2?

0 Answers  

---

what is cursor stability?

2 Answers   IBM,

---

What is buffer pool in the db2 database?

0 Answers  

---

explain about index with examples

2 Answers   Syntel,

---

What is the database descriptor?

2 Answers  

---