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 |
What is the purpose of the PARM keyword in the EXEC statement?
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
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?
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 ?
whats the difference between empty and noempty of GDG?
Suppose I have a program in cobol name ”careerride” and want to execute the program by jcl. Specify the process?
if we compile the cobol+ db2 program now ofter 5 years we need to compile again?
Describe the JOB statement, its meaning, syntax and significant keywords?
Can we Execute a job without specifying Job Name in the Job Card?
01 A. 10 B pic X(10). move spaces to A. move spaces to B. output in A & B
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