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 condition checking in jcl? Is this possible?
How to alter the parameters for the existing gdg?
Explain dd statement in jcl?
What is 'mounting' of volumes ? Is there anything that a programmer can do in it ? How to find currently mounted volume ?
I have a cobol db2 program(PGM A) where other program (PGM B) will call this program and passes some 50 fields data to PGM A. PGM A has some layout in which it receives the data from PGM B. And this layout has been copied in the linkage section pf PGM A. After getting the data, PGM A writes the data in a flat file in the same layout which it receives from PGM B. PGM B is a simple COBOL pgm. Please provide a JCL to run these programs.
How to pass data to a program that is coded in an exec statement?
Explain the job statement in jcl?
what is DSN in JCL and what are the parameters to declare the DSN?
what is the resolution for sb37 error
Must tape dataset definitions include vol=ser specifications?
What is the function of //jcllib statement?
How is a type of file defined in the jcl that executes the cobol program?
If a (+1) generation dataset is created in the first step of a job, how can it be referenced in later steps of the same job for input?
What do you understand by the term notcat 2 – gs?
What are the parameter we cannot use in procedure?