View previous topic :: View next topic
|
Author |
Message |
ozgurseyrek
New User
Joined: 22 Feb 2008 Posts: 70 Location: Turkey
|
|
|
|
Hello,
my inout data is like that;
Code: |
DENIZ ;60001 ;15.01.2008;G10;11 ; 000000000000080,00;
DENIZ ;60005 ;18.01.2008;BUS;10 ; 000000000000455,00;
DENIZ ;60006 ;01.02.2008;T10;10 ; 000000000000240,00;
DENIZ ;60007 ;05.02.2008;T20;10 ; 000000000000069,00;
DENIZ ;60008 ;15.01.2008;G10;11 ; 000000000000000,00;
DENIZ ;60014 ;29.01.2008;G10;11 ; 000000000000000,00;
|
I want to output same data plus 1 line at the bottom (Totals of last column);
Code: |
DENIZ ;60001 ;15.01.2008;G10;11 ; 000000000000080,00;
DENIZ ;60005 ;18.01.2008;BUS;10 ; 000000000000455,00;
DENIZ ;60006 ;01.02.2008;T10;10 ; 000000000000240,00;
DENIZ ;60007 ;05.02.2008;T20;10 ; 000000000000069,00;
DENIZ ;60008 ;15.01.2008;G10;11 ; 000000000000000,00;
DENIZ ;60014 ;29.01.2008;G10;11 ; 000000000000000,00;
000000000000844,00;
|
is it possible? |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Here's a DFSORT job that will do what you asked for:
Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file
//SORTOUT DD DSN=... output file
//SYSIN DD *
OPTION COPY
OUTFIL REMOVECC,
TRAILER1=(45:TOT=(45,18,UFF,EDIT=(TTTTTTTTTTTTTTT,TT)),C';')
/*
|
|
|
Back to top |
|
|
ozgurseyrek
New User
Joined: 22 Feb 2008 Posts: 70 Location: Turkey
|
|
|
|
thank you very much... |
|
Back to top |
|
|
|