SortCL job scripts -- whether written with your preferred text editor, CoSort's free Java GUI, or API call to the sortcl_routine() -- deliver these core reporting functions:
Condition Logic
Record filtering and field evaluation
Field Remapping
Re-size, re-cast and re-position fields
File Reformatting
Create, collate and convert 20+ formats
Type Conversion
Translate between data types
Segmentation
Sort, join and select to capture and group
Summarization
Count, total, average, maximum, minimum
Cross-Calculation
Intra-record math and trig operations
Regular Expressions
Pattern matching, find/replace, etc.
and include these formatting options:
Page Layouts
Header/footer formatting, records-per-page, etc.
Shell Values
Leverage environment and internal variables
HTML Support
Embed W3C metadata to create web-ready reports
Field Padding
Byte shifting, alignment, and fill features
Dashboards
CSV or XML exports feeds interactive, visual BI tools
User Exits
Custom input, compare and/or output procedures
Complex Transforms
Field-level, external library functions
Character Validation
Compare routines for type conformance
Conclusion:
SortCL is designed for simultaneous back-end and front-end
processing (report generation) in many data warehousing, ODS, decision
support, data federation and EII environments. It also offers integrated
transformation, protection, and reporting functionality that may
be suitable for some BI purposes. In addition, CoSort offers a powerful
dashboard option to enable a more seamless flow of data from ETL
to BI.
