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
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is commit in db2?
What is phantom read in db2?
How does db2 sample database connect?
What is table space in db2?
What's The Percentage Free Space ?
Can there be more than one cursor open for any program?
How do I add a column in db2?
What's The Error Code For Unique Index Voilation?
What is the difference between db2 and oracle?
What is the maximum length of sqlca?
Give the name of some fields form sqlca.
What is the information associated with sysibm.syslinks table?
What is the syntax for creating a table in the db2 database?
How and when does the db2 enforces the unique key?