Every time the value of the first four digits under the heading ENTITY changes ( 0701 to 0703, or 0703 to 0704..etc ) i want to introduce a page break ( an empty record )
and print the following header :
Code:
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8-
ACCOUNT PRODUCT ENTITY CURR MAINT DATE PREV MAINT DATE
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
Look up SortWriter in your Syncsort documentation.
Here is a list of reporting capabiities (possibly not complete because the info is not from the current release):
Quote:
The SortWriter capability of OUTFIL can produce completely formatted reports. The report
writing features, which can be specified differently for each output file, can accomplish
these tasks:
• Arrange the report into pages.
• Divide the report into sections.
• Format headers and trailers for sections, pages, and the complete report.
• Create multiple lines of output from each input record.
• Convert and edit numeric data.
• Provide TOTAL and SUBTOTAL capabilities for data fields in a specific part of a
report.
• Provide MIN, MAX, AVERAGE, SUBMIN, SUBMAX, and SUBAVG capabilities for
data fields in a specific part of a report.
• Provide COUNT and SUBCOUNT capabilities for records in a specific part of a report.
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
Hello,
Here's a SyncSort job which would work for your requirement. Note that you'll have one additional blank line at the end of the report.
I assumed files of FB/LRECL=81 as shown in your example.