delete rules in db2
Answer / 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 |
How to execute step2,step1, step3 if step1,2,3 are in order
What are the parameter we cannot use in procedure? How many instream we can write in single jcl?
How to identify in JCL that an input file is empty without reading it?
What are the common jcl syntax errors you get? This is not abends?
Could anyone please suggest me what is the maximum length of data that can be pass as input in //sysin dd * This was asked in interview. TIA
How do you submit JCL via a Cobol program?
what is the difference between return code and maxcc?
I have an job having three job steps.Suppose i want to call a pgm in step2 and aproc in step3.How to write the code?
wht is sysudump n sysout,sysprint ?
Can we change the LIMIT of GDG?
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?
How system will identify whether user wants to create PS or PDS? If answer is SPACE parameter then why we need to pass ps or po as dataset organisation while creation