MVSFORUMS.com

madisand · Beginner Joined: 29 Aug 2005 Posts: 19 Topics: 7

Hi

I want to sort a file considering all the fields in it (it include alphanumeric, ZD,PD etc & is 4043 byte length long) & eliminate duplicates . Is there any tip by which I can avoid coding in the control card all the sort fields
& in one shot remove duplicates

Thanks

Phantom · Posted: Fri Sep 16, 2005 6:50 am Post subject:

madisand,

You don't have to code all the fields in your sort card. You can either use CH or BI as the SORT format, for all fields. There is no need to differentiate them as ZD/PD - for your case.

CH and BI formats support upto 4092 characters for SORT - Max length.

Use this

madisand · Beginner Joined: 29 Aug 2005 Posts: 19 Topics: 7

Thanks Phantom,

It worked. I tried with CH option. Due to time constraints couldn't try with BI option & will do it once I get a chance.

Frank Yaeger · Posted: Thu Sep 22, 2005 6:44 pm Post subject:

One caveat: CH/BI will only work for ZD/PD in this case if the positive values all have the same sign (e.g. all F signs or all C signs). It will not work if they have mixed signs (e.g. some have F signs and some have C signs). Admittedly, mixed signs are not commonly used, but they're also not unheard of.
_________________
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

Phantom · Posted: Fri Sep 23, 2005 12:33 am Post subject:

Thanks for the info. Frank. Never heard of a situation like this. But I will definitely keep this in mind if I come across another post like this.

Thanks,
Phantom