how to split a file
Answers were Sorted based on User's Feedback
Using SORT utility we can split the file. Sort card will be
as:
//SYSIN DD *
SORT FIELDS=COPY
OUTFILE FNAMES=(SORTOUT1,SORTOUT2,SORTOUT3),SPLIT
/*
If there are 10 records in input and these have to be split
across three files SORTOUT1, SORTOUT2 and SORTOUT3
respectively. After running the Job using this sort card,
record1 would be stored in SORTOUT1, record2 in SORTOUT2,
record3 in SORTOUT3, record4 in SORTOUT1 and so on.
| Is This Answer Correct ? | 18 Yes | 0 No |
Answer / thavasi
USE ICETOOL to split the records from a single file into two
output files. Do a search in google, you will get lot of
ICETOOL JCL for this requirement.
Thanks,
Thavasi
| Is This Answer Correct ? | 5 Yes | 4 No |
Answer / shubhanshu sharma
//SORT01 DD DSN = PDS,
DISP = (NEW,CATALOG,DELETE),
DCB = (RECFM = F, LRECL = 80, BLKSIZE = 800),
UNIT = SYSDA,
VOL = WRKA97
SPACE = (CYL,(1,4),RLSE)
//SORTIN DD*
SORTFIELD = COPY,
SKIPREC = 100,
STOPREC = 80.
/*
SKIPREC means how many records we need to skip
STOPAFT means how many records we need to put in the
file.
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / kalpana
Using the sort card we can split the file.
//SYSIN DD *
SORT FIELDS=COPY,SKIPREC=56910,STOPAFT=25
/*
SKIPREC means how many records we need to skip and STOPAFT
means how many records we need to put in the
file.
| Is This Answer Correct ? | 5 Yes | 10 No |
What is a MODEL Paramater in GDG ?
CAN ANYONE TELL ME WHAT IS "JOB-CARD"
Mention the types of job control statements?
Can we use DISP=SHR in output file in JCL
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
What parameters can be used to limit the number of records written to a sysout dataset?
what is alternate index?
how to eliminate the duplicates in sorting
What is order of searching of the libraries in a JCL?
what is the difference between the JCLLIB and JOBLIB ,and where do we use it ?
Current version of GDG is ID.GDG.FILE.G0001V00. JCL has procedure with 2 steps like below, What will be the output file name in each step ? PROC starts Step 1 has ID.GDG.FILE(+1) Step2 has ID.GDG.FILE(+4) PEND Similarly, JCL has 2 steps in 2 separate procedure. What will be the output file names here ? PROC starts Step 1 has ID.GDG.FILE(+1) PEND PROC1 starts Step2 has ID.GDG.FILE(+4) PEND
What is the purpose of dd?