JCL

Hi, I have a VB file Organization  . . . : PS   Record format . . . : VB   Record length . . . : 32566 Block size  . . . . : 32570 The data length would not be consistent for each record and the maximum length of the record would be a maximum […]

As with any technology when you go for an interview you want to get prepared for the standard interview questions and some of those tricky ones that the interviewer may get you into trouble. JCL is an important part of any mainframe interview and so the website is proud to come up with the section

USING SUPERCE TO COMPARE TWO DATASETS (IN BATCH) The following JCL can be used to compare two datasets using the SUPERCE batch utility. //SUPERCE  JOB (XXXXXXXX,,,,,XXXX),’               ‘,           //SUPERC  EXEC PGM=ISRSUPC,                          

JCL Interview Questions ·        What is the difference between primary and secondary allocations for a dataset? Ans:-Secondary allocation is used when more space is required than what has already been allocated by primary. ·        How to access a file that had a disposition of KEEP? Ans:-Since the file is not in catalog you will need

If you wish to exclude certain records which match a specific criteria.(Using OMIT) OMIT COND=((34,2,CH,EQ,C’AB’),AND,(74,1,CH,EQ,C’ ‘))  The above SORT card will exclude records which have ‘AB’ at 34th position and have spaces at 74th position. Example JCL is provided below. ; ; ; ; //SORTIN   DD DISP=SHR,DSN=USERID.ABC.INPFILE, //SORTOUT  DD DSN=USERID.ABC.OUTFILE, //      SPACE=(TRK,(30,10),RLSE),

REMOVING DUPLICATES FROM INPUT FILE AND WRITE DUPLICATES TO A FILE     //SREMDUPL JOB (XXXXXXXX,,,,,XXXX),’        ‘,       //             CLASS=J,MSGCLASS=Y,NOTIFY=&SYSUID,    //* THIS JOB SORTS THE INPUT FILE AND REMOVES        //* WRITES DISTINCT  RECORDS IN SORTOUT          

SORT JCL to SUM up values If you wish to sum up the values at a particular position sorted at some value then you can use the following sort card The following card will sum values (lets assume salaries) appearing at pos 7th (4 bytes) grouped/sorted on data (emp numbers) at 37th position of 10bytes.

IEBEDIT Example- JCL to submit particular steps of another JCL You may get a scenario where you wish to submit/execute only particular steps of a jcl and exclude  others. Although this can be handled by using COND parameter but this would require editing the original JCL to include COND parameter at each step and may

SORT JCL to append data in a record using INREC or OUTREC There may be instances when you wish to append some data at the end or between a record. The following SORT parm will come handy in such situations The following sort card will add char ‘LITERAL’ in the output file at 5th position.