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.

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

2023

---

Give the name of some fields form sqlca.

1043

---

List down the data types in the db2 database.

1065

---

What is buffer pool and list some of them?

999

---

What is deadlock in db2?

1037

---

What do you mean by cursor?

959

---

How do you find the maximum value in a column in db2?

1077

---

define clustering index.

994

---

What does a deadlock mean in DB2?

1126

---

Which component is used to execute the sql statements?

1069

---

When the like statement is used?

1175

---

what is the sqlcode -501

12993

---

How to run db2 command in windows?

1158

---

Define data page.

1035

---

What is the result of open cursor statement?

1049

---