delete rules in db2



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

Post New Answer

More JCL Interview Questions

What is the purpose of the PARM keyword in the EXEC statement?

3 Answers  


We have 100 steps in a procedure and we need to run the jcl and execute only 25th step in the proc and not the remaining steps. How can we do it?

5 Answers   IBM, JPMorgan Chase,


by using cond parameter maximum 8 cond can be coded in single cond means ?explain

0 Answers  


if in a job, region is mentioned in both jobcard and in step then which is cosidered at the step level? A job has region 4k in jobcard and step1 with region 0k and step2 with 16k, then what is the region allocated for the entire job? what is the region step1 takes? what is the region step2 takes?

4 Answers  


The disp in the JCL is MOD and the program opens the file in OUTPUT mode. What happens ? The DISP in the JCL is SHR and the program opens the file in EXTEND mode. What happens ?

3 Answers  






whats the difference between empty and noempty of GDG?

4 Answers   Patni,


Suppose I have a program in cobol name ”careerride” and want to execute the program by jcl. Specify the process?

0 Answers  


if we compile the cobol+ db2 program now ofter 5 years we need to compile again?

1 Answers   TCS,


Describe the JOB statement, its meaning, syntax and significant keywords?

1 Answers  


Can we Execute a job without specifying Job Name in the Job Card?

2 Answers  


01 A. 10 B pic X(10). move spaces to A. move spaces to B. output in A & B

2 Answers   Perot Systems,


i have a jcl containing header body and trailer .in header i have viswa body 2 6 1 9 7 trailer reddy .now i need to sort only body in either asecending or descending order how can i do it

1 Answers   L&T,


Categories