Answer / s

tables that are connected in a referential integrity
relationship. Delete of the primary keys deletes the
corresponding foreign keys.

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

---

How does a cursor work?

0 Answers  

---

What is the logical entity between plan and Package?

5 Answers  

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

---

What are the Isolation levels possible ?

5 Answers  

---

What are some characteristics of columns that benefit from indexes?

1 Answers  

---

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

---

How Plan is created while executing the query using SPUFI?

3 Answers  

---

Comment whether the cursor is closed during commit or not.

0 Answers  

---

What is the use of reorg in db2?

0 Answers  

---

Can a Db2 table data be retrived through JCL?

4 Answers  

---