Can we calculate the sum of alphanumeric character.

sadashiv.a.bhosure · New User Joined: 01 Feb 2007 Posts: 15 Location: india

Hi,

suppose file contain number in alpahnumeric format(left align). I want to treat this alphanumeric data as a number and find out the total.
I/p file ---> data in alphanumeric format

guptae · Posted: Thu Feb 22, 2007 1:17 pm

Hi There,
Please show us an example including i/p & o/p

sadashiv.a.bhosure · New User Joined: 01 Feb 2007 Posts: 15 Location: india

here is the i/p file

-------------------------------------------
Name(1-10) count(11-20)
alphabetic alphanumeric
-------------------------------------------
aaaa 1 ----> left align alphnumeric data
bbbb 1
aaaa 2
bbbb 4

I want output as
o/p=>
aaaa 3
bbbb 5

I have tried following, it gives SOC7 error
SORT FIELDS=(1,10,CH,A)
SUM FIELDS=(11,20,ZD)

I have also tried
SORT FIELDS=(1,10,CH,A)
SUM FIELDS=(11,20,UFF)

but it doesn't work.

Could you please tell me is there are any other option available in JCL?

Thank you so much.

Regards,
Sadashiv.

sadashiv.a.bhosure · New User Joined: 01 Feb 2007 Posts: 15 Location: india

Is there any other option available in JCL or whether I have to write a program for changing alphanumeric field to numeric field and then calculate the total.

waiting for your precious reply.

thanks in advance,

Regards,
Sadashiv.

Frank Yaeger · Posted: Thu Feb 22, 2007 9:56 pm

You need to use UFF format to convert the values to ZD, SUM the ZD values and then convert them back to the form you want. If you want the values left justified, you need to use JFY.

Here's a DFSORT job that will do what you asked for. You'll need z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006) in order to use DFSORT's JFY function. If you don't have the April, 2006 PTF, ask your System Programmer to install it (it's free). For complete details on all of the new DFSORT and ICETOOL functions available with the April, 2006 PTF, see:

Use [URL] BBCode for External Links