View previous topic :: View next topic
|
Author |
Message |
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.
Code: |
//SYSIN DD *
INCLUDE COND=(1,8,CH,EQ,C'LINE')
SORT FIELDS=(1,8,CH,A)
SUM FIELDS=(22,4,BI)
OUTREC FIELDS=(1,8,5X,22,4)
/*
|
This showing all the records satisfying the INCLUDE COND.
Early Help will be appreciated |
|
Back to top |
|
|
prakash271082
New User
Joined: 09 Sep 2005 Posts: 53
|
|
|
|
Hi,
Try SUM FIELDS with ZD option. |
|
Back to top |
|
|
Direction
New User
Joined: 15 Sep 2005 Posts: 11
|
|
|
|
Thanx Kathiresan,
It works, thanx for ur favour. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
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. |
|
Back to top |
|
|
|