Hi,
My dataset have multiple records, say 100. I want to start
copy records only after a record contain a specific value
that may be in a specific position. Secondly I want to stop
copying rest records if certain record contains a specific
value. Can it be done using SORT/ICETOOL utilities?
Answer Posted / eswaran
hi,
your dataset have 100 records then u want copy starting
position=25 to ending position=50 then y have copy following way
//FSS129A JOB
//STEP1 EXEC PGM=SORT
//SORTIN DD DSN=NEW1.PS
//SORTOUT DD DSN=NEW2.PS
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY,SKIPREC=25,STOPAFT=50
/*
//
Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
A dd statement consists of 4 fields. Name them?
What is the difference between the positional and keyword parameters? Give examples.
What are the parameter we cannot use in procedure? How many instream we can write in single jcl?
IIN APITUDE THEY GAVE ONLY 10 QUESTIONS.. THEY ARE SIMPLE ONE FROM NUMBER SERIES,BOATS,TIME & DISTANCE,PROFIT &LOSS,FIND OUT THE NUMBER ? 9 25 4 36 81 64 49 AND surveillance SPELLINGS E.T.C
in ways data can be passed to a COBOL program from JCL?
Explain about ISPF/TSO Commands
what happens when COND is coded in JOB statement and when COND is coded inside EXEC statement?
Name the parameters which can be used to limit the number of records written to a sysout dataset?
What is the purpose of disp parameter?
What parameter of the job statement is used to limit the cpu time consumed by the job?
Explain dfsort utility?
Explain how can the submitting users racf authority be overridden in a job stream?
Where can program checkpoints be stored for use in a restart?
what is the difference between JES3 and JES2?
1) SORT FIELDS=(20,4,CH,D,10,3,CH,D) OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7, 24,57,TRAN=LTOU,6X'FF') This example illustrates how a fixed-length input data set can be sorted and reformatted for output. The SORTIN LRECL is 80 bytes. The reformatted output records are fixed length with a record size of 103 bytes. SOLRF (the IBM-supplied default) is in effect, so unless the SORTOUT LRECL is specified or available, it will automatically be set to the reformatted record length of 103. in the above example i have some doubts that a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does and this fields related to output record fields or input record fields b)outrec used to refprmat the records after sorting that means could please reply me as soon as possible Thanks. Venkat