The file has two fields:
1) ID Nbr - X(19)
2) Amount value - X(19) - this field contains amount values. There's anegative sign at the end if it's a negative value. Thus, 123456789123456.34- is numerically -123456789123456.34.
I need a trailer record at the end of the file with the following values:
1) Count of the number of detail records in the file.
2) Sum of the amount values in each of the detail record. The problem is that the amount value in the detail records is alphanumeric.
Can someone suggest a way to do this without eazytrieve or a program. I
need to do this by something like DFSORT.
You'll need z/OS DFSORT V1R5 PTF UQ95214 or DFSORT R14 PTF UQ95213 (Dec, 2004) in order to use DFSORT's SFF and larger numbers functions. Only DFSORT has these functions, so if you don't have DFSORT, you won't be able to use them. If you do have DFSORT, but you don't have the Dec, 2004 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 Dec, 2004 PTF, see:
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Wed Jan 18, 2006 5:39 pm Post subject:
heman wrote
Quote:
Hi Frank,
I have tried executing with the given DFSORT syntax but it gives me the following error which I'm unable to rectify.
Gee, I thought I was pretty clear about only DFSORT supporting SFF and larger number functions when I said:
Quote:
You'll need z/OS DFSORT V1R5 PTF UQ95214 or DFSORT R14 PTF UQ95213 (Dec, 2004) in order to use DFSORT's SFF and larger numbers functions. Only DFSORT has these functions, so if you don't have DFSORT, you won't be able to use them.
Or maybe you didn't know you were using Syncsort? _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Yes, this JCL does work but the only problem is that the negative sign in the output "TOTAL AMOUNT VALUE" doesn't get displayed properly. It gets displayed as '}'.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum