Values repeated more than Once

ap_mainframes · Posted: Fri Oct 03, 2008 5:29 am

Hi,

My input file looks like this

Policy1 USA
Policy1 CANADA
Policy1 MEXICO
Policy2 USA

What I need to do is, if the feild 1 ( in this case Policy1 & Policy2) is repeated more that once, then I need to write it in another file.
Note that Policy2 is not repeated,hence it should not be written.

Hence, My output file should look like this

Policy1 USA
Policy1 CANADA
Policy1 MEXICO

Note that SUM FEILDS=NONE and XSUM wont work here.

The file is 80 bytes long. Feild 1 starts from position 1 and feild 2 from 10.

Please advise.

Thanks,

gcicchet · Posted: Fri Oct 03, 2008 6:40 am

Hi,

try this

ap_mainframes · Posted: Fri Oct 03, 2008 9:08 am

Thanks Gerry, It does work. But we are not allowed to use ICETOOL in production. ICEMAN is allowed though.
Any other solutions please ?

Thanks

gcicchet · Posted: Fri Oct 03, 2008 10:30 am

Hi,

here is another way, I'm sure someone will come up with something different

expat · Posted: Fri Oct 03, 2008 11:27 am

Frank Yaeger · Posted: Fri Oct 03, 2008 8:34 pm

ICETOOL has been part of DFSORT since 1991! It's fully documented and supported. It's ridiculous for a shop not to allow it in production.

ap_mainframes · Posted: Fri Oct 03, 2008 9:32 pm

Unfortunately, that is the case here. They dont allow us to move ICETOOL in prod.

Frank Yaeger · Posted: Fri Oct 03, 2008 10:25 pm

Just out of curiosity, have they ever given you a reason why? Do they realize they're paying for functionality that they're not letting you take advantage of?

Skolusu · Posted: Fri Oct 03, 2008 11:22 pm

ap_mainframes,

The following DFSORT JCL will give you the desired results.The job uses DFSORT's new WHEN=GROUP functions available with z/OS DFSORT V1R5 PTF UK90013 (July, 2008).

If you don't have z/OS DFSORT PTF UK90013, ask your System Programmer to install it (it's free).

For complete details on the new functions available with PTF UK90013, see:

Use [URL] BBCode for External Links