using SQZ justify with outfil trailers



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

using SQZ justify with outfil trailers

Postby wolfi57 » Tue Dec 27, 2016 5:42 pm

i'm using section trailers3 for summing amount , but now I need to reformat that line to justifying to left and squeeze all spaces du to my edit mask for pd field

it is my actual output
1;2014;1000; 0,00; 1234,55; 0,00;
1;2014;2000; 0,00; 1234,55; 0,00;
1;2015;2000; 0,00; 1234,55; 0,00;
2;2015;2000; 0,00; -1234,55; 0,00;

how to obtain ( csv format to be import in excel )

1;2014;2000;0,00;1234.55;0,00;
1;2014;6000;0,00;1234.55;0,00;
1;2015;6000;0,00;1234,55;0,00;
2;2015;6000;0,00;-1234,55;0,00;

my jcl

OUTFIL REMOVECC,NODETAIL,
SECTIONS=(1,11,
TRAILER3=(1,1,C';',2,4,C';',8,4,C';',
TOT=(33,7,PD,EDIT=(SIIIIIIIIT,TT),SIGNS=(,-)),
C';',
TOT=(12,7,PD,EDIT=(SIIIIIIIIT,TT),SIGNS=(,-)),
C';',
TOT=(54,7,PD,EDIT=(SIIIIIIIIT,TT),SIGNS=(,-)),
C';'))
wolfi57
 
Posts: 10
Joined: Fri Dec 16, 2016 10:51 pm
Has thanked: 0 time
Been thanked: 0 time

Re: using SQZ justify with outfil trailers

 

Re: using SQZ justify with outfil trailers

Postby BillyBoyo » Tue Dec 27, 2016 8:59 pm

Sorry, it won't work.

Why do you "need" it? What part of the world is going to stop revolving if it is not left-justified?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 263 times

Re: using SQZ justify with outfil trailers

Postby wolfi57 » Tue Dec 27, 2016 9:21 pm

Just wondering, no sp├ęcial need, so if its not possible i can deal with
wolfi57
 
Posts: 10
Joined: Fri Dec 16, 2016 10:51 pm
Has thanked: 0 time
Been thanked: 0 time

Re: using SQZ justify with outfil trailers

Postby BillyBoyo » Tue Dec 27, 2016 10:05 pm

OK, so, "now I would like to know if it is possible" rather than "now I need" :-)
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 263 times

Re: using SQZ justify with outfil trailers

Postby NicC » Wed Dec 28, 2016 2:32 am

And you have not shown any JCL - just sort control cards and they are not JCL.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2662
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 100 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post