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

what is static and dynamic call with examples?

4 Answers   IBM,

---

How system will identify whether user wants to create PS or PDS? If answer is SPACE parameter then why we need to pass ps or po as dataset organisation while creation

1 Answers  

---

Hi Please try to be to-the-point. 1) How to INCLUDE a JCL segment in a JOB ? (A Small example) 2) What is SPOOL and what is SPOOL FULL ? and how to direct the output of a Jobstep to SPOOL ?

3 Answers   IBM,

---

Is it possiable to use a gdg in the INCLUDE statement in a SORT jcl? I am using this because I want to change the condition with out changing the jcl. Please provide with a sample code.

1 Answers  

---

What you mean by skeleton JCl?

2 Answers  

---

How to find the number of duplicates in a file using Sort?

4 Answers   Fidelity,

---

I have 255 procedures in a job, each procedure contain 2 steps.can we execute this job?

2 Answers  

---

what is inrec fields and outrec fields in sorting

3 Answers   Fidelity,

---

what's the significance of freespace(0 0) and freespace(100 100)

3 Answers  

---

If there are five steps in a JCL i have to execute the 3rd step, bypass the 4th step and execute the 5th step how do i do this?

13 Answers   Cognizant, Convergys, IBM, TCS, Wipro,

---

how to modify the copy book?explain with examples

2 Answers   TCS,

---

//S10 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //CON DD DSN=VAR.INPUT1,DISP=SHR // DD DSN=VAR.INPUT2,DISP=SHR //OUT DD DSN=VAR.OUTPUT,DISP=(NEW,CATLG,DELETE), // SPACE=(CYL,(5,5)),UNIT=SYSDA //TOOLIN DD * * Splice the needed data from the two VB files together SPLICE FROM(CON) TO(OUT) ON(5,5,CH) WITHALL - WITH(12,5) WITH(22,20) VLENMAX /*

0 Answers  

---