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
how can the same proc be re-used and called by many jobs?
Name what parameter directs the output of the job log dataset?
How can the disposition of sysout datasets be set for an entire jobstream?
What is multithreading in jcl?
What do you understand by the term notcat 2 – gs?
Are there any set of rules for the names of the steps used in a job? What are they?
if the submitter of a job wants to inform another user about the job completion, how can it be done?
Explain the function of job statement in jcl?
How to code these statements in JCL: CLEANUP INITIAL(NO) RESTART(NO) DYNALLOC(NO) job definition..?
How to alter the parameters for the existing gdg?
a dd statement has 2 types of parameters. Name them?
How does the jcl specify the job to os?
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?
which parameter is use to declare the name of dataset in dd statement?
What is the function of the dd dcb keyword?