delete rules in db2
- 1 Answers
- 7494 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
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 |
What are the 2 types of parameters in dd statement?
What is the significance of addrspc parameter in exec statement?
what happens when COND is coded in JOB statement and when COND is coded inside EXEC statement?
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) ?
A. Job Abended in STEP03. Now run job again to execute STEP03, STEP04 (STEP01,STEP02 should not execute again)
3 Answers Cap Gemini, CSC, Xchanging,
Can we use DISP=SHR in output file in JCL
What is the error in the following JCL statements : I) //step#three exec pgm=hkbc762 ii) //step#3 exec pgm = hkbc762 iii) //step#3 exec pgr = hkbc672
Can a job have only steplib and no joblib ?
how do u see jobs submitted before ur job ?
How to override loadlib?
what is alternate index?
What is the use of disp parameter?
COBOL 
