Interested to Buy Any Domain ? << Click Here >> for more details...
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 is the function of //jcllib statement?
How can values be passed from the job stream to an executable program?
What is the format of comment statement?
a set statement is used to define commonly used symbolic across job steps or procedures. It initializes the previous values in the symbolic names. It has to be defined before the first use of the symbolic names in the jcl. State whether true or false?
I want to join to input files and write the matching fields on to an output file but i dont want the output file a sorted one
When you specify multiple datasets in a JOBLIB or STEPLIB, what factor determines the order?
What do you understand by jcl?
write a jcl to execute a job by 7:00 am on jan 20,1986?
I had Records in file Like this Company Code IBM 2 IBM 1 IBM 4 WIPRO 3 WIPRO 2 WIPRO 9 TCS 4 TCS 6 TCS 3 i want the record of every company with highest code How can i do that?
What is the use of disp parameter?
What parameter of the job statement is used to limit the cpu time consumed by the job?
We can use PASS with permanent datasets also. THEN Which is the condition in which we may use PASS (instead of KEEP) with permanent data sets, while there is no need to specify UNIT and VOL for them like temporary data sets (in cas we use KEEP for permanent data sets) ?
List the various advantages of using jcl language?
how to run batch program without jcl?
Explain the function of dd name parameter with a 2 part structure; audit.report?
