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
What are s0c1, s0c4, s0c5, s0c7 and socb?
Is it possible to code instream data in a PROC?
Why block size is multiple of lrecl in jcl?
Explain the purpose of dd * statement in jcl?
What is the difference between the positional and keyword parameters? Give examples.
How does jcl specify the job to the operating system?
//S10 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //CON DD DSN=VAR.INPUT1,DISP=SHR // DD DSN=VAR.INPUT2,DISP=SHR //OUT DD DSN=VAR.OUTPUT,DISP=(NEW,CATLG,DELETE), // SPACE=(CYL,(5,5)),UNIT=SYSDA //TOOLIN DD * * Splice the needed data from the two VB files together SPLICE FROM(CON) TO(OUT) ON(5,5,CH) WITHALL - WITH(12,5) WITH(22,20) VLENMAX /*
Is there any command to check wether the ps file is in sorted order?
What are the rules employed while naming the steps in a job?
what are the statements that are not valid to be included in an include statement?
Explain about LMFREE�free data set from its association with data ID
What are the 2 types of parameters in dd statement?
What parameters can be used to limit the number of records written to a sysout dataset?
what operation is performed by job statement?
Explain how can an in-stream dataset be terminated?
