CoSort's SortCL data transformation tool also works hand-in-hand with
unload tools. For Oracle and DB2, SortCL takes piped data from CoSort's
FAst extraCT (FACT) and pipes it pre-sorted into database load utilities
like SQL*Loader.
SortCL's familiar and intuitive data definition language (DDL) uses symbolic field-names and metadata repositories to:
• Map sources to targets
• Reduce script sizes and creation times
• Speed table creation, load and file-compare metadata
SortCL job scripts contain SQL-like data manipulation language (DML) commands that use and/or reference those data layouts.
4GL SortCL jobs get run from the command line, in batch scripts, from 3GL programs, and via a state-of-the-art, cross-platform Java GUI. SortCL and related facilities in CoSort can accept many third-party data layouts (e.g. COBOL copybooks, CSV, CLF and ELF web logs and SQL*Loader Control File metadata. Meta Integration Technology, Inc. (MITI) has created a metadata model bridge (MIMB) for SortCL's data definition file format so you can leverage your tool's file layouts in adjacent SortCL jobs.
SortCL, as with other CoSort user interfaces, exploits CoSort's granular performance tuning and flexible CPU licensing. Continuing innovation in parallelism, I/O, data manipulation routines, and industry partnerships keep CoSort at the leading edge of commercial data sorting and related file processing.
With CoSort, you can run end-to-end reorg and flat-file data warehouse extract-transform-load (ETL) operations
at the industry's highest data volume and performance levels.