Page 1 of 1

adding fields in the OUTPUT section of Visual Syncsort

PostPosted: Mon Jan 04, 2016 6:32 pm
by maildeep07
I have a report that is getting created through VSS. The Report looks like
Ram       555
Shyam    888
John       777
Harry     666

I want the total of all the numbers in my report. So that the report looks like.
Ram       555
Shyam    888
John       777
Harry     666
TOTAL  2886

Please put some light in this? I am using VSS for syncsort.

Coded

Re: adding fields in the OUTPUT section of Visual Syncsort

PostPosted: Mon Jan 04, 2016 6:58 pm
by BillyBoyo
Visual SyncSort is, seemingly, an old PC-based version of SyncSort. Is that what you are running, or something on a Mainframe? Do you have documentation for the product? Without seeing your code, it is also difficult to make the best suggestions.

Re: adding fields in the OUTPUT section of Visual Syncsort

PostPosted: Mon Jan 04, 2016 7:48 pm
by maildeep07
No it is the PC-based version I am using. It just creates the sort card that we can use in our jobs for different sorts in SYSIN.

Re: adding fields in the OUTPUT section of Visual Syncsort

PostPosted: Mon Jan 04, 2016 8:24 pm
by BillyBoyo
OK, for the actual thing you want it is probably OUTFIL with REMOVECC, TRAILER1 with some text and TOT/TOTAL for the field you want added up.

Re: adding fields in the OUTPUT section of Visual Syncsort

PostPosted: Mon Jan 18, 2016 10:13 pm
by Alissa Margulies
As BillyBoyo pointed out, if you want the report TOTAL, then you can use OUTFIL TRAILER1. Please keep in mind, however, that Visual SyncSort for z/OS has been out of support since June 2013, and will not contain support for any new syntax or features created since that time.