Answer Posted / 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.

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2315

---

Mention some fields that are a part of sqlca.

1008

---

What parameters are used to control the free space in DB2?

1041

---

What is runstats and reorg in db2?

1286

---

What is the physical storage length of time data type?

1108

---

What is dbrm? What it contains? When it will be created?

1032

---

Explain about rct in db2?

1091

---

What is a db2 schema?

1211

---

Is it possible using max on a char column?

1123

---

What is plan in cobol db2?

1114

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

1044

---

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1263

---

What is ibm db2 database?

991

---

define clustering index.

1010

---

what is diffrence b/w file-aid tool and file-aid utility???

4875

---