IBM Mainframe Forum

by **gabrielp** » Tue Feb 18, 2014 9:28 pm

I have an step thar I want 2 files out. Fisrt of them i'd like all regs sorted. The second one, i'd like all regs sorted but, i'd like the maximiun value of (05,26) for each duplicated keys.

can I do it this way?

SORT FIELDS=(01,04,BI,A)
OUTFIL FILES=01,
OUTREC=(01,50)
OUTFIL FILES=02,
DUPKEYS MAX=(05,26,BI)

thanks

by **BillyBoyo** » Tue Feb 18, 2014 10:42 pm

No, but have look at OUTFIL reporting features,

by **gabrielp** » Tue Feb 18, 2014 10:57 pm

do you know any other way do do this in 1 sept?

by **dick scherrer** » Wed Feb 19, 2014 12:42 am

Hello and welcome to the forum,

do you know any other way do do this in 1 sept?

i do not understand what this is asking . . .

Please clarify.

d

by **gabrielp** » Wed Feb 19, 2014 7:37 pm

do you know how can i do it (I want 2 files out. Fisrt of them i'd like all regs sorted. The second one, i'd like all regs sorted but, i'd like the maximiun value of (05,26) for each duplicated keys.) using only one step.

by **dick scherrer** » Thu Feb 20, 2014 12:53 am

Hello,

You really need to make sure of the spelling of what you post. . . . The 1 sept was a mystery . . .

I suppose regs are records?

Suggest you post some sample input data and the outputs you want from that sample input.

by **gabrielp** » Thu Feb 20, 2014 1:17 am

input
0001gabriel20
0001gabriel50
0001gabriel30
0002roberta10
0002roberta60
0002roberta20

output1:
0001gabriel20
0001gabriel30
0001gabriel50
0002roberta10
0002roberta20
0002roberta60

output2:
0001gabriel50
0002roberta60

by **Thampy** » Thu Feb 20, 2014 3:19 am

You can use OUTFIL SECTIONS to achieve the result you are looking for.

//STEP010 EXEC PGM=SORT
//SORTIN DD *
0001GABRIEL20
0001GABRIEL50
0001GABRIEL30
0002ROBERTA10
0002ROBERTA60
0002ROBERTA20
//SORTOF1 DD SYSOUT=*
//SORTOF2 DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=(1,13,CH,A)
OUTFIL FILES=1,BUILD=(1,80)
OUTFIL FILES=2,REMOVECC,NODETAIL,SECTIONS=(1,4,
TRAILER3=(1,13))
//*

SORTOF1 output
0001GABRIEL20
0001GABRIEL30
0001GABRIEL50
0002ROBERTA10
0002ROBERTA20
0002ROBERTA60

SORTOF2 output
0001GABRIEL50
0002ROBERTA60

by **BillyBoyo** » Thu Feb 20, 2014 12:59 pm

Yes, but are you going to show the use of MAX?

by **gabrielp** » Thu Feb 20, 2014 6:26 pm

yes MAX

IBM Mainframe Forum

Use DUPKEYS with OUTFIL

Use DUPKEYS with OUTFIL

Re: Use DUPKEYS with OUTFIL

Re: Use DUPKEYS with OUTFIL

Re: Use DUPKEYS with OUTFIL

Re: Use DUPKEYS with OUTFIL

Re: Use DUPKEYS with OUTFIL

Re: Use DUPKEYS with OUTFIL

Re: Use DUPKEYS with OUTFIL

Re: Use DUPKEYS with OUTFIL

Re: Use DUPKEYS with OUTFIL