The SortCL job scripts that CoSort users write -- with any text editor, CoSort's free Java GUI for SortCL, or an 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
Expressions
PCREs, 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 data-type conformance
Conclusion:
CoSort's SortCL program is designed for either back-end data preparation (data franchsing) or front-end
processing (report generation) in many data integration, ODS, decision
support, data federation and EII environments. It also offers data warehouse transformation functions, field-level protection, and detail and summary reporting functionality suitable for 2-dimenstional business intelligence. In addition, CoSort offers the powerful
iDashboards option to enable a more seamless flow of data from ETL
to BI.
