SyncSort Reports

socker_dad · Posted: Mon Oct 29, 2012 7:45 pm

New topic for SyncSort! (And not related to any of my previous posts).

I've been asked to generate a quick report from a rather large input file that sums on three fields, producing a header, five summary lines and a footer.

Getting the report formatted - and with correct totals - was a breeze. Now I need some help with a couple of "small" formatting issues:

1. The only lines to appear on the report are the ones show below - not the 367,000 file records that I cannot seem to suppress (is there some sort of a NODETL command?).

2. The lines should appear consecutively, with no gaps, i.e., the header on lines 1 & 2 and the trailer lines on 54+).

3. The total records processed should be formatted with commas to separate millions & thousands: 366,499 - not 366499. ANd it should be right-aligned with the other totals - I can force it with the starting position, if I know the total, but if it goes over or under the hundred thousand records, it is misaligned.

Here's where I'm at:

Bill Woodger · Posted: Mon Oct 29, 2012 7:53 pm

If you only want HEADERn and TRAILERn lines, use NODETAIL.

Bill Woodger · Posted: Mon Oct 29, 2012 7:59 pm

If you look at the definition of COUNT15 you may see how to get your commas and how to get it to align due to being the same length as the other fields.

socker_dad · Posted: Mon Oct 29, 2012 8:00 pm

Dang it - I need a syncsort spellchecker......

Still trying to squeeze it down to 9 sequential lines - I've tried the LINES command, but that doesn't seem to work.

Bill Woodger · Posted: Mon Oct 29, 2012 8:05 pm

What you need is to indicate when you've edited your post :-) I kept looking, changing mine, then looking back and yours is different again...

Run with the NODETAIL. For the spacing after that, look at your documentation, use scissors and glue on the "interim" report.

Let us know.

socker_dad · Posted: Mon Oct 29, 2012 8:14 pm

Sorry Bill, I hate mispelling words. And I forgot to include my code.

NODETAIL worked great!

And I discovered that what you see in SYSOUT is NOT always what you get in a dataset. It turns out that I was actually getting the line spacing exactly as I wanted, but the SYSOUT on the JESLOG was displaying a lot of extra blank lines.

The last detail (and I have RTFM several times for this!) is formatting the record count in an edited format, with commas. I have tried both COUNT and COUNT15 (couldn't tell any difference between the two), but it will not permit an edit parameter.

Bill Woodger · Posted: Mon Oct 29, 2012 8:23 pm

For DFSORT COUNT= allows an EDIT to be applied. If there is nothing similar in your manual, then perhaps a "workaround". If you include a SEQNO on the end of each record, you should find that the value from the final detail record is available on the trailer. That you should be able to EDIT. I can't test this on SyncSort, and don't need to on DFSORT :-)

My spell-checker is inbillt in the browser, only failes me when I ignor it.

dick scherrer · Posted: Mon Oct 29, 2012 9:02 pm

Hello,

Syncsort allows an EDIT.

This is working for a non-zerosuppressed record count:

socker_dad · Posted: Thu Nov 01, 2012 12:47 am

That did the trick, Mr. Scherrer.

Thanks for all the help folks!

dick scherrer · Posted: Thu Nov 01, 2012 1:37 am

Good to hear it worked for you - thanks for letting us know

d