Repeat same sequence in output file



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Repeat same sequence in output file

Postby Eric » Fri Feb 12, 2010 1:57 am

Hi,

I want to repeat tree channel 1,2,3 in the first position in the output file. I use this but the result repeat 1 to 9 and zero for each ten record.

OPTION COPY -
OUTREC OVERLAY=(1:SEQNUM,1,ZD)

The result i want is :

1
2
3
1
2
3
:

Can you help me ?
Thanks !
Eric
Eric
 
Posts: 6
Joined: Fri Feb 12, 2010 1:40 am
Has thanked: 0 time
Been thanked: 0 time

Re: Repeat same sequence in output file

 

Re: Repeat same sequence in output file

Postby Frank Yaeger » Fri Feb 12, 2010 2:19 am

If I understand correctly what you want, this DFSORT job should do it:

//S1    EXEC  PGM=SORT
//SYSOUT    DD  SYSOUT=*
//SORTIN DD DSN=...  input file
//SORTOUT DD DSN=...  output file
//SYSIN    DD    *
  OPTION COPY
  INREC IFTHEN=(WHEN=GROUP,RECORDS=3,PUSH=(1:SEQ=1))
/*


If that doesn't give you what you want, then you need to be explain more clearly what you do want with an example of your input records and expected output records, RECFM, LRECL, etc.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

Re: Repeat same sequence in output file

Postby Eric » Sat Feb 13, 2010 3:10 am

Hi Mr. Yaeger

that is what I was looking for,

thank you for your availability...

Eric
Eric
 
Posts: 6
Joined: Fri Feb 12, 2010 1:40 am
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post