SORT JCL to filter data using INREC or OUTREC INREC can be used to filter or reformat the input data so that the sorting is more efficient. In the following sort card the inrec statement will take the data from 7th pos (3 bytes) and put at positions 1st(3bytes) in the  output file and […]
SORT JCL to filter data using INREC or OUTREC Read More »
SORT JCL to Mask output data  If you wish to format the data then  you can specify the edit mask by using the following sort card. In this card The date in the 60th position in the input file is in the format YYYYMMDD and in the output file it will be formatted as
SORT JCL to Mask output data Read More »
CONVERTING A FILE IN VB FORMAT TO FB FORMAT //SORTIN Â DD DSN=USERID.ABC.VBFORMAT,DISP=SHR Â Â //SORTOUT Â DD DSN=USERID.ABC.FBFORMAT, Â Â Â Â Â Â Â // Â Â Â Â Â Â DISP=(,CATLG,DELETE),UNIT=SYSDA, Â Â Â // Â Â Â Â Â Â DCB=(LRECL=80,RECFM=FB) Â Â Â Â Â Â Â Â Â OUTREC FIELDS(1:20,80),CONVERT Â Â Â Â Â
JCL TO CONVERT VB TO FB FILE Read More »
Precompile compile and link edit jcl for cobol db2 program The following JCL can be used for compilng and link editing a COBOL DB2 program. This JCL has mainly three steps The PRE COMPILATION Step executes the utility DSNHPC and uses the COBOL DB2 program present in source library and copy library for DCLGEN’s  as input
precompile compile and link edit jcl for cobol db2 program Read More »
LIST MIGRATED DATASETS STARTING WITH A QUALIFIER //LSTMIGR Â JOB (XXXXXXX,,,,,XXXX),’ Â Â Â Â ‘, Â Â Â Â Â Â Â Â Â Â Â // Â Â Â Â Â Â CLASS=T,MSGCLASS=Y,NOTIFY=&SYSUID, Â Â Â Â Â Â Â Â Â Â //STEP000 Â EXEC PGM=IEFBR14 Â Â Â Â Â Â Â Â
JCL to List Migrated Datasets Read More »
SORT JCL with STOPAFT and SKIPREC If you wish to skip certain number of records and stop sorting after certain number of records then you can use the following SORT parm SORT FIELDS=COPY,SKIPREC=x,STOPAFT=y x is the number of records which are to be skipped while sorting y is the number of records after which sorting
SORT JCL with STOPAFT and SKIPREC Read More »
LISTING ALL DATASETS STARTING WITH A PARTICULCAR FIRST LEVEL QUALIFIER This JCL will search for all the Data sets starting with “USERID” as the first level qualifier The results will be written to spool (in SYSTSPRT). Â It will also show the status (active / migrated) and other information. //LISTDSN Â JOB (XXXXXXXX,,,,,XXXX),’ Â Â Â
JCL to list all datasets starting with Read More »
JCL to Unload all members of PDS in a PS Flat file. There may be instances when  you wish to unload all the members in a PDS to a flat file so that you may print them (later read them) or transport the data from mainframe to your pc and work with this data. IBM
JCL to Unload all members of PDS in a PS Flat file. Read More »
JCL FOR SPLITTING DATA USING OUTFIL The following JCL can be used for splitting files using SORT OUTFIL. //SORTJCL Â JOB (XXXXXXXX,,,,,XXXX),’ Â Â Â Â Â Â Â ‘, Â Â Â Â Â Â Â Â Â Â // Â Â Â Â Â Â REGION=0M,NOTIFY=&SYSUID Â Â Â Â Â Â Â Â Â
JCL FOR SPLITTING DATA USING OUTFIL Read More »
Why do we code BLKSIZE=0 in JCL At our mainframe shop, there are many jcl’s which use BLKSIZE=0 for the datasets which are cataloged by the JCL. From what I learnt during my training the BLKSIZE has to be a multiple of  and would mean the number of logical records to be clubbed in a physical record
Why do we code BLKSIZE=0 in JCL Read More »
