Answer Posted / gowrinag

FOREIGN KEY YFK (YNO) REFERENCES Y
ON DELETE CASCADE,
FOREIGN KEY ZFK (ZNO) REFERENCES Z
ON DELETE RESTRICT)
IN OZAGENDB.OZAGENTS;

ex:

CREATE TABLE YZ
(YNO CHAR(5) NOT NULL,
ZNO CHAR(5) NOT NULL,
QTYINTEGER,
PRIMARY KEY (YNO,ZNO),
FOREIGN KEY YFK (YNO) REFERENCES Y
ON DELETE CASCADE,
FOREIGN KEY ZFK (ZNO) REFERENCES Z
ON DELETE RESTRICT)
IN OZAGENDB.OZAGENTS;


---------+---------+---------+---------+---------
YNO ZNO QTY
---------+---------+---------+---------+--------
Y1 Z1 300
Y2 Z2 400

Define db2.

1096

---

How to check last update on table in db2?

1039

---

How to create backup table in db2?

1067

---

How is deadlock resolved?

1120

---

What parameters are used to control the free space in DB2?

1038

---

What is db2 look?

1007

---

What are the uses of db2 optimizer?

1274

---

How can you count the number of rows from a table tab?

1075

---

What does sqlcabc has?

1030

---

What is cloudant database?

1077

---

B37 abend during spufi?

1442

---

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1258

---

What is cursor with hold option in db2?

1052

---

Explain about open switch business continuity software?

1111

---

What is database manager in db2?

1001

---