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
- 11163 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 | 3 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 run cobol program using jcl?
how can u understand ps and pds from their names ?
I have 3 duplicate records in a file . I want to eliminate 1st, 2nd and copy 3rd one only . HOW ?
is there any utility for restarting a particular step in jcl reply soon ?
Suppose i have 2 steps in my pgm. Step1- creates a file, Step2 - generates report from file in step1, What changes have to be made in Step2, so that if the file in Step1 is empty Step2 should not be executed? No changes to be made to Step1.
Explain about LMMLIST�list a library's members
THERE IS ONE STEP AS BELOW: //STEPJS060 EXEC PGM=XYX, COND=((200,EQ,JS010),(0,NE,JS020.C),EVEN) COULD ANY ONE EXPLAIN HOW COND PARAMETER WORKS HERE? I AM CONFUSED BECOZ OF "EVEN".
Hi, Say I have 10 flat files and I want to copy all these 10 flat files to a GDG versions flat files (I have GDG base: FDWS01.TEST.RESTORE) in one shot. Can we do that in one shot using a JCL. May be by using IEBGENER. It's a bit urgent. So anyone's fast rely would be appreciated.. Thanks in advance.. 10 flat files ----------------------------------- FDWS01.SUB.RESTORE1 FDWS01.SUB.RESTORE2 FDWS01.SUB.RESTORE3 ; ; FDWS01.SUB.RESTORE10 TO GDG versions ----------------------- FDWS01.TEST.RESTORE.G0001V00 FDWS01.TEST.RESTORE.G0002V00 FDWS01.TEST.RESTORE.G0003V00 ; ; FDWS01.TEST.RESTORE.G0010V00
List the various advantages of using jcl language?
What is the difference between IEBGENER, IEBCOPY and REPRO in IDCAMS utility?
what is the difference between static call and dynamic call?
How do you overcome this limitation ?
COBOL 
