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 / nnn
If you want to copy value of 'A' at 10 th position
SORT FIELDS=(COPY)
INCLUDE COND=(10,1,CH,EQ,C'A')
If you want to stop copy value of 'A' at 10 th position
SORT FIELDS=(COPY)
INCLUDE COND=(10,1,CH,NE,C'A')
Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
What is the function of dd name parameter with a 2 part structure; audit.report?
What does a disposition of (MOD,DELETE,DELETE) mean ?
Can I send output of job to my remote device careerride123?
what is SOC4 error?
What are the jcl procedures?
What is the function of the dd dcb keyword?
When you specify multiple datasets in a JOBLIB or STEPLIB, what factor determines the order?
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
What do you know about jcl?
what is DD statement is used in JCL?
What is the function of the dd mgmtclas keyword in sms datasets?
What statement marks the beginning of a job step; assigns a name to the step; identifies the program or catalogued or in-stream procedure to be executed in the step?
why should SYSIN DD * statement should not be included inside a PROCedure snippet??? please answer this.. i need to know.
what are the various stages of job processing?
Are there any set of rules for the names of the steps used in a job?