Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

how can the same proc be re-used and called by many jobs?

1511


Name what parameter directs the output of the job log dataset?

1056


How can the disposition of sysout datasets be set for an entire jobstream?

1348


What is multithreading in jcl?

1473


What do you understand by the term notcat 2 – gs?

1243


Are there any set of rules for the names of the steps used in a job? What are they?

1080


if the submitter of a job wants to inform another user about the job completion, how can it be done?

1250


Explain the function of job statement in jcl?

1213


How to code these statements in JCL: CLEANUP INITIAL(NO) RESTART(NO) DYNALLOC(NO) job definition..?

2256


How to alter the parameters for the existing gdg?

1204


a dd statement has 2 types of parameters. Name them?

1135


How does the jcl specify the job to os?

1159


in a jcl, a large volume dataset is loaded to a table using bmcload in step1 and an image copy of the loaded table is taken using bmccopy in step2. Step2 abends because the image copy dataset cannot hold the volume of the table. How can this be rectified?

1301


which parameter is use to declare the name of dataset in dd statement?

1272


What is the function of the dd dcb keyword?

1342