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.

What are packages in db2?

1071

---

What is syscat in db2?

1068

---

What is alias in db2?

1108

---

How can you do the explain of a dynamic sql statement?

1106

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2261

---

List some fields from sqlca?

1102

---

Which isolation level provides highest data integrity?

1180

---

What is a db2 package?

1119

---

What is difference between isnull and coalesce?

1104

---

Explain about rct in db2?

1160

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2906

---

What is the difference between oracle and db2?

1167

---

What is the role of the data page in the db2 database?

1082

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2155

---

Is the primary key a clustered index?

1198

---