delete rules in db2

Answer Posted / vinay sonar

There are 3 rules

PARENT TABLE CHILD TABLE

ON DELETE SET NULL DELETE SET NULL

ON DELETE CASCADE DELETE DELETE

ON DELETE RESTRICT DELETE NO CHANGE

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In job processing, what happens in conversion stage?

725


State the uses of syspring, sysin, sort fields, sum fields and dummy.

638


How dummy is used in jcl?

639


How is the record format of an output dataset specified?

734


How do you create a temporary dataset?

650






IIN APITUDE THEY GAVE ONLY 10 QUESTIONS.. THEY ARE SIMPLE ONE FROM NUMBER SERIES,BOATS,TIME & DISTANCE,PROFIT &LOSS,FIND OUT THE NUMBER ? 9 25 4 36 81 64 49 AND surveillance SPELLINGS E.T.C

1621


Explain dfsort utility?

658


How do you access an uncatalogued dataset in a jcl?

718


Differentiate between the joblib and the steplib statements?

850


How can an in-stream dataset be terminated?

838


What is the use of symbol // in jcl?

916


Is it possible to code instream data in a PROC?

740


What dd statement is used to supply the name of a dataset?

768


How can the attributes of one sms dataset be copied to another dataset?

844


What is the difference between run mode and addressing mode?

625