Just encountered a problem ..
If I have my data as 150.000 AND 75.00 what should the data type be in the syntax Could u tell me also what the type FS IS.
If I have my data as 150.000 AND 75.00 what should the data type be in the syntax
You need to show me what your input data really looks like and what you want for output. Do you really have mixed 3 decimal and 2 decimal values? If so, are the decimal points in the same position in each record?
Please use ubb code tags around the data so we can see what it really looks like. If you don't know how to use ubb code tags, then use a b for each blank in the data.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Well, your numbers don't add up, so it's hard to tell what the amounts represent (e.g. you have one aa3 record with 3 and 150.00 for input, but you show a count of 2 for output and a cost/plan that doesn't make any sense). However, I'll take a shot and assume that count is the total of the first amount for each key, cost/plan is the average of the second amount for each key and total/cost is the total of the second amount for each key. Given that, here's a DFSORT job that will give you the kind of report I think you're asking for.
I have tried the synatx but I ma getting a u0016 error
could u help me please
TRAILER3=(23,5,
59:TOT=(7,2,FS,EDIT=(TTTTTTT)),
121:TOT=(15,8,UFF,EDIT=(TTTTTTT.TT)),C'0',
*
152:TOT=(15,8,UFF,EDIT=(TTTTTTT.TT)),C'0')),
TRAILER1=(80'-' ,/,'TOTALS :' ,
59:TOT=(7,2,FS,EDIT=(TTTTTTT)),
*
121:TOT=(15,8,UFF,EDIT=(TTTTTTT.TT)),C'0',
*
152:TOT=(15,8,UFF,EDIT=(TTTTTTT.TT)),C'0')
*
the * indicate where the error is
The plan count column starts from 59 ,the total-profit-amt column starts from 124 and the total-liability column from 152..
59:TOT=(7,2,FS,EDIT=(TTTTTTT)),
121:TOT=(15,8,UFF,EDIT=(TTTTTTT.TT)),C'0',
*
152:TOT=(15,8,UFF,EDIT=(TTTTTTT.TT)),C'0')),
TRAILER1=(80'-' ,/,'TOTALS :' ,
59:TOT=(7,2,FS,EDIT=(TTTTTTT)),
*
121:TOT=(15,8,UFF,EDIT=(TTTTTTT.TT)),C'0',
*
152:TOT=(15,8,UFF,EDIT=(TTTTTTT.TT)),C'0')
*
the * indicate where the error is
The plan count column starts from 59 ,the total-profit-amt column starts from 124 and the total-liability column from 152..
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
The WER messages indicate you're using Syncsort, not DFSORT. DFSORT supports UFF. Syncsort does not support UFF, so you can't use the technique I showed with Syncsort as you could with DFSORT.
Note that I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.