Can SQL statements/queries be included in a copybook?

2 Answers  

---

What is SPUFI?

4 Answers  

---

Define db2.

0 Answers  

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,

---

What is sqlcode -922 ?

2 Answers  

---

What is db2 isolation?

2 Answers  

---

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  

---

What else is there in the PLAN apart from the access path?

1 Answers  

---

Give the name of some fields form sqlca.

0 Answers  

---

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

What is a DB2 plan?

8 Answers  

---