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.

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  

---

What are foreign keys?

1 Answers  

---

What is runstats db2?

0 Answers  

---

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

0 Answers  

---

how to fetch first 100 rows in db2

2 Answers   IBM,

---

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  

---

What are host variables in db2?

0 Answers  

---

Which are the db2 tools to protect integrity of the database?

0 Answers   IBM,

---

how will you retrieve first record in table

1 Answers   UST,

---

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

---

What does an outer join do?

1 Answers   CTS,

---

When is the access path determined for dynamic SQL?

2 Answers  

---