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 |
suppose i have job it contains 10 steps after exicution of job failuer at 3 and 7 th steps i want exicute step 3 and step 7 only how we specify condition ?
What is STEPLIB, JOBLIB? What is it used for?
How to pass the parameter in parm using linkage section ? (syntax)?
Where & How Do You Code Identifier In Jcl?
What is the difference between primary and secondary allocations for a dataset?
Is it possiable to use a gdg in the INCLUDE statement in a SORT jcl? I am using this because I want to change the condition with out changing the jcl. Please provide with a sample code.
How to check empty file in jcl?
Explain about Cobol Subroutines
how do you resolve for soc7 error
What are the parameters that are used in creating a gdg?
What is the difference between specifying DISP=OLD and DISP=SHR for a dataset?
How to pass data to a program that is coded in an exec statement?