MVSFORUMS.com

[vijayakumar]

Hi

i want to find a max of two fields in the record and place it in two separate files.

EX:

pol23454920
pol23564930
pol23754940
pol23964510
pol24454960
qte25564970
pol26454980
pol37564410
pol24455910
pol25565710
qte25568910
qte28563910
qte29566910

i want the fields from position 4 to 7 and 8 to 11 with maximum value written to two separate files

file1 :3756
file2: 8910

can you just help me using sort utility

Regards
vijay

[kolusu]

vijayakumar,

Try this job

[vijayakumar]

hi kolusu

The sort job works fine .

Regards & Thanks

vijay

[vijayakumar]

hi

This sort works good for zd but for binary with 4 bytes i changed the zd to BI but it gives error whether any modification is to be made for existing.

Regards
vijay

[Cogito-Ergo-Sum]

[kirank]

Hi,

SORT FIELDS=COPY
OUTFIL FNAMES=FILE1,REMOVECC,NODETAIL,
TRAILER1=(MAX=(4,4,ZD,M11))
OUTFIL FNAMES=FILE2,REMOVECC,NODETAIL,
TRAILER1=(MAX=(8,4,ZD,M11))

in the above statements i've few doubts. Could you pls clarify the following:

1) What is REMOVECC,NODETAIL
2) What is M11 in the TRAILER1=(MAX=(4,4,ZD,M11))

Thanks,
Kirank.

[kolusu]

[Frank Yaeger]

Kirank,

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

[sreenivask]

I have a similar requirement,but i have to get the maximum of those two outputs in a file and I want to do it in the same step.The output of the above mentioned input in the begining has to be 8910. I tried the follwong,but ended up only to get both those in a single file. I don't know how to get maximum of those two outputs(trailers) in the same step.

//SYSIN DD *
SORT FIELDS=COPY
OUTFIL FNAMES=FILE1,REMOVECC,NODETAIL,
TRAILER1=(MAX=(4,4,ZD,M11)),
TRAILER2=(MAX=(8,4,ZD,M11))
/*

I want the maximum of these two trailers in the same step.Can some one help me?
How to give multiple conditions in that MAX field? How to get maximum of those two trailers in the same step?

[Frank Yaeger]

If you want the two maximums in the same record, change your OUTFIL statement to something like this:

[kolusu]

sreenivask,

Try this

[sreenivask]

Thanks for your replies. But what I need is the maximum of these two maximums.

The above solution gives the out put as
3756
8910

But I need the out put as the maximum of these two and I want to do it in the same step.Out put should be
8910

Thanks
Srinivask

[kolusu]