Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 12863 Views
- Patni, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / muttaiah
Hi Subrat,
can you cleary mention your query.
you want to start copying only after a particular record
contains a value & stop after you find a value in
particular record.
EX:
100 muttaiah hyd
200 kiran hyd
300 Guru hyd
400 ram hyd
500 narayana hyd
600 hari hyd
consider you input file has 5 records. You want to copy
only when you find 200 in the record & stop when you find
500 in the record
Output:
300 Guru hyd
400 ram hyd
Is this what your question exactly MR. Subrat,
@All:
All the previous answers are wrong
The one who posted i kindly request them to read the
question twice before they post. As number of people are
going to visit this site.
Thanks,
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 | 4 No |
Answer / 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 |
Answer / pavan
can anyone provide full syntax wth an example..please
| Is This Answer Correct ? | 0 Yes | 5 No |
How to execute only th 15th step of JCL consisting of 50 steps?
How to find the number of duplicates in a file using Sort?
Explain the function of dd name parameter with a 2 part structure; audit.report?
a input file contains 1000 records, how to move the first 500 record into one out put file and how to move to second 500 records to anothere output file
how to compress the data set
What are steplib and joblib?
i have a file which contains duplicates ? my requirement is to eliminate duplicates and these elminated duplicates should be moved to another file can any code this using sort ?
what r the types of job control statements?
describe the exec statement,its meaning ,syntax and keywords?
Explain concatenating datasets?
What is the difference between these two parameters? -> accounting information -> class how would it bring the differrence to a program?
Can we create VSAM file by using IEBGENER?
COBOL 
