Sum the hexadecimal input and diplay the totals

to_sreeni · New User Joined: 08 Jul 2009 Posts: 17 Location: bangalore

Hi,

I have a requirement to sum the hexadecimal fields of an input file and write the totals out.

We have SYNCSORT FOR Z/OS 1.4.0.0.

The input file is VB, REC Length = 250

Sample input is

expat · Posted: Wed Jul 10, 2013 6:09 pm

What have you tried so far and what were the results ?

And please learn to use the CODE tage

to_sreeni · New User Joined: 08 Jul 2009 Posts: 17 Location: bangalore

Hi,

I tried the below SYSIN cards.

Nic Clouston · Posted: Wed Jul 10, 2013 7:40 pm

If you got the correct output then they are correct. If you did not then they are incorrect.

to_sreeni · New User Joined: 08 Jul 2009 Posts: 17 Location: bangalore

Hi Nic,

I have not got the expected output.
I have not go the totals for distinct values in column 11.

It was showing many rows with the column 11 data, e.g. 'W' in column 11 with many rows.

I am not sure where the problem is.

Any suggestion is greatly appreciated.

Thanks
Sreeni

Nic Clouston · Posted: Wed Jul 10, 2013 8:04 pm

Well, in your 'sample' input in col 11, for 1 byte, both records have x'00'. are you trying to sort on col 15 ('P') perhaps? And similar error elsewhere.

to_sreeni · New User Joined: 08 Jul 2009 Posts: 17 Location: bangalore

It is actually 7th character. Since the input file format is VB, I have added another 4 bytes for RDW. I was lokking for 'W' in the sample records (after PADA).

Hope this will help.

Nic Clouston · Posted: Wed Jul 10, 2013 8:28 pm

OK - because you did not use the code tags your sample is all skew-wiff. Can someone a) remove the leading blank on line 1 and b) remove the and on both lines so that we have a clearer picture, please?

dick scherrer · Posted: Wed Jul 10, 2013 8:57 pm

Hello,

Here's the sample data revised:

Sample input is

Nic Clouston · Posted: Wed Jul 10, 2013 9:10 pm

Thanks, Dick. Looks like my preview button isn't missing either as the bold/unbold tags did not display but bolded the 'and'. Brain-fade on my part!

Akatsukami · Posted: Wed Jul 10, 2013 10:01 pm

to_sreeni · New User Joined: 08 Jul 2009 Posts: 17 Location: bangalore

I tried without OPTION ZDPRINT. But i was not getting the expected output. I do not mind if the output is in hexadecimal format, i will convert that to decimal format manually as i am expecting only 15 distinct sums (from the original input file).

My Input file has 15 distinct values in column 11. But in the output i was getting more than 15 sums.

Can somebody help?

Akatsukami · Posted: Thu Jul 11, 2013 4:01 pm

Then in your output data set, you must have at least one key duplicated, no? What are those duplicates?

to_sreeni · New User Joined: 08 Jul 2009 Posts: 17 Location: bangalore

In the input file, I have nearly 650K records. But there are only 15 distinct values in character 11. But the output file has displayed 383 records, which i could not understand. I can't provide the complete input file due to Data protection Act.

I could not understand the reason for duplicate output records. can anybody think of any reason for this?

Akatsukami · Posted: Thu Jul 11, 2013 5:17 pm

Unfortunately, I can give you no hope save to work with your shop's senpai, as no solution is possible without examining the data.

Nic Clouston · Posted: Thu Jul 11, 2013 5:54 pm

Well, try VIEWing the file and edit it as follows: