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 difference between JES3 and JES2?
What are the rules employed while naming the steps in a job?
what is use of dsn parameter in dd statement?
Can we call instream to catalog and catalog to instream?
In job processing, what happens in conversion stage?
Is there any command to check wether the ps file is in sorted order?
Immediate Job opening for mainframe professionals in Keane Bangalore. Please find the below details: Organization: Keane India Location: Bangalore Skill: COBOL, JCL,VSAM,DB2,CICS,IMS,REXX,CLIST Exp: 1 to 4 years only Employment Type: Permenant Employee Note: If you have attended keane interview in past 6 months please ignore this job opening. Please respond to email id keanemfjob@gmail.com OR keanemfjob@yahoo.in with your latest resume and following details, We will contact you within 24 hours: Total IT Exp: Exp in Mainframe: Current CTC: Expected CTC: Notice Period:
what EXEC statement is and what is the syntax of EXEC statement used in JCL?
why should SYSIN DD * statement should not be included inside a PROCedure snippet??? please answer this.. i need to know.
What is the significance of addrspc parameter in exec statement?
hello friends ,i have exam in Hsbc,pls any on send me placement papers and technical questions on mainframes,thank u
Differentiate between the joblib and the steplib statements?
Where can program checkpoints be stored for use in a restart?
What are the parameter we cannot use in procedure?
How can the attributes of one sms dataset be copied to another dataset?