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
- 12603 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 |
What is JCL LIB ?
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
I have an job having three job steps.Suppose i want to call a pgm in step2 and aproc in step3.How to write the code?
in order to execute step2 a job after a return code of 8 in step1, what condition you will code in step2?
describe the exec statement,its meaning ,syntax and keywords?
Definition of COND parameter in JCL
COND -> step1 . . step2, Step2, Executes if the CC of step1 is 0. But even if it is NOT 0 and if we dont give COND, will step2 be executed ?
Is there any command to check wether the ps file is in sorted order?
Can I concatenate various datasets whose organization are different from each other. Lets say I want to cancatenate a PDS file, a PS file, a GDG file etc. Can You do that ?? If yes, how ? is there any separate Utility to do so ???
Explain the function of the dd dcb keyword?
In SPACE,what is directory,RLSE
What is a GDG? Why do we go for a GDG ? utility used to create GDG?
COBOL 
