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.

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

---

If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  

---

What type of database is db2?

0 Answers  

---

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

0 Answers  

---

What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,

---

What is QUIESCE?

2 Answers  

---

How can you compare table column after update and before update?

5 Answers   Satyam,

---

What do you need to do before you do EXPLAIN ?

1 Answers  

---

How to access db2 tables in mainframe?

0 Answers  

---

How do we specify index to include or not during bind process.

0 Answers   Satyam,

---

What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  

---

B37 abend during spufi?

0 Answers   IBM,

---