Compare a subselect to a join?

1 Answers  

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

What is commit in db2?

0 Answers  

---

How to update more then one record using update?

5 Answers   IBM,

---

Comment whether the cursor is closed during commit or not.

0 Answers  

---

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  

---

What is the physical storage length of date data type?

0 Answers  

---

What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,

---

What does CURRENTDATA option in bind indicate

1 Answers   IBM,

---

What information is contained in a SYSCOPY entry?

2 Answers  

---

What is cursor with hold option in db2?

0 Answers  

---

Where is the access path logic created by the DB2 Optimizer stored?

1 Answers  

---