Answer / 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

Answer / guest

A foreign key establishes the referential constraint
between a parent table and a dependent table

What is a db2 schema?

0 Answers  

---

What is bufferpool in db2?

0 Answers  

---

What do you do to keep the cursor from closing after a commit?

1 Answers  

---

What is meant by union and union all?

0 Answers  

---

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---

pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,

---

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

---

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

What is cursor stability in db2?

0 Answers  

---

what's the error code for Unique Index Violation?

2 Answers  

---

What does the REORG Utility do?

2 Answers  

---

What is clone table?

0 Answers  

---