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 EXEC statement is and what is the syntax of EXEC statement used in JCL?
How do you access a file that had a disposition of KEEP?
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".
how will be submit 1 jcl by other jcl? means that how 'll submit one job by other job??
Is condition checking possible in jcl? If yes, how?
Can we able insert data into a PS file Using IEBUPDTE utility??? If Yes can anyone describe it please..
Explain about RECORDING MODE Clause
Can a job have only steplib and no joblib ?
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 ?
Explain about LMGET�read a logical record from a data set
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?
State the uses of syspring, sysin, sort fields, sum fields and dummy.