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.

How to find the number of rows in db2 tables?

607

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1587

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2683

---

What is a collection in db2?

576

---

What is universal database?

609

---

---

What is a plan and package in db2?

609

---

What are bind parameters in db2?

607

---

Is db2 a database?

569

---

What is table space in db2?

572

---

What is dbrm library?

571

---

What is null in db2?

569

---

Is the primary key a clustered index?

603

---

What is concurrency?

702

---

What is the use of dclgen in db2?

586

---

What is null value in db2?

557

---