Translating mainframe binary data types (like COMP), and typical data type conversions like these:
• integer to currency
• EBCDIC to ASCII
• packed or zoned decimal values to binary integer
• European timestamp to ISO timestamp
• floating point to numeric
traditionally require separate tools and I/O passes,
and in some cases, consultants. Going the other way (i.e. ASCII to packed)
can be especially problematic.
Solutions:
Data type translation is just one of many transformation and reporting
options in a CoSort SortCL job script. While mapping
data from input to output, simply specify the source and target data types
in the field specification. In fact, many people have SortCL scripts
just to quickly convert EBCDIC fields to ASCII, or packed to numeric, for
example, with or without sorting.
CoSort can collate (sort), convert between, and randomly
create fields in more than 100 data types, including C, COBOL and
numeric types, multi-byte Chinese, Japanese and Korean characters, IP addresses,
currency, timestamps, and more.
Contact IRI to discuss your particular requirements. It is also possible to provide a customized data type conversion routine for special data sets, and for CoSort to convert between many different file formats at the same time.