JCL : SUM of particular field required from the input file

Direction · New User Joined: 15 Sep 2005 Posts: 11

Hi all,

I am writing a JCL, in which I want to find out the SUM of particular field in a specific OCCURRENCE OF line items(which had a prefix 'LINE') . And it is not giving me the SUM as over flow error is coming in field on which adding is carried out.

Here is sample code which i am using :
I am using a SORT pgm for this.

SORTIN GIVES THE INPUT FILE FOR THE PROGRAM.

prakash271082 · Active User Joined: 09 Sep 2005 Posts: 61

Hi,
Try SUM FIELDS with ZD option.

Direction · New User Joined: 15 Sep 2005 Posts: 11

Thanx Kathiresan,

It works, thanx for ur favour.

Frank Yaeger · Posted: Tue Oct 25, 2005 9:30 pm Post subject:

Kathiresan,

Good guess considering you had no idea what the data actually looks like.

Direction,

You must use the correct format for the data you're dealing with. If ZD worked for you, then your data looks like this in hex: FdFdFdsd where d is a digit (0-9) and s is the sign (C, F or D). When you tried to SUM this as BI (binary), you got overflow because of the first F in each field. With ZD, the Fs are ignored and the sddd values are summed.