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 EXEC statement is and what is the syntax of EXEC statement used in JCL?

0 Answers  


How do you access a file that had a disposition of KEEP?

3 Answers  


THERE IS ONE STEP AS BELOW: //STEPJS060 EXEC PGM=XYX, COND=((200,EQ,JS010),(0,NE,JS020.C),EVEN) COULD ANY ONE EXPLAIN HOW COND PARAMETER WORKS HERE? I AM CONFUSED BECOZ OF "EVEN".

2 Answers  


how will be submit 1 jcl by other jcl? means that how 'll submit one job by other job??

3 Answers   Steria,


Is condition checking possible in jcl? If yes, how?

0 Answers  






Can we able insert data into a PS file Using IEBUPDTE utility??? If Yes can anyone describe it please..

1 Answers  


Explain about RECORDING MODE Clause

1 Answers  


Can a job have only steplib and no joblib ?

6 Answers  


1) Is CLASS used for assigning Priority (as we say a job having class '6' will run before the job having class '5'? then what is the difference between CLASS and PRTY ? 2) In a same JCL, 2 JOB statements with different Classes and NO PRTY are submitted ? which will run first ? & with different classes and different PRTY also, which will run first now ?

3 Answers   IBM,


Explain about LMGET�read a logical record from a data set

1 Answers  


i have 10,000 records in one input file.i want to sort 1 to 5000 records in one outputfile and remaining records sort in another output file write the syntax for this?

4 Answers   DELL,


State the uses of syspring, sysin, sort fields, sum fields and dummy.

0 Answers  


Categories