Translating mainframe binary data types (like COMP), and typical data type conversions like these:
- EBCDIC to ASCII
- packed or zoned decimal values to binary integer
- numbers to currency
- European to ISO timestamps
- floating point to numeric
- big to little endian
traditionally requires separate tools and I/O passes and, in some cases, consultants. Going the other way (i.e., ASCII to packed) can be difficult.
Data (and File) Type Conversion Only
IRI-Supported Data Type Groups
- ASCII / C
- EBCDIC MF
- Packed Decimal
- EBCDIC RM
- Zoned Decimal
IRI NextForm software converts data types as you migrate, replicate, or federate files and tables. Translate source fields from EBCDIC to ASCII, packed decimal to numeric, American to ISO timestamp, IP address to whole number, etc. Save time and money using NextForm to convert between more than 100 built-in (or custom-defined) data types.
NextForm also converts files and databases from one format to another. This is useful in application modernization, mainframe migrations, data replication, and ETL scenarios. With NextForm, you can translate a Micro Focus COBOL I-SAM file into a text file, LDIF to CSV, upgrade or leave Oracle, etc. NextForm can also: reformat records; manipulate field elements; filter, validate and scrub data; and, generate custom reports.
Data Migration, Transformation, and Reporting
The conversion of data types is only one of the many reformatting options in IRI CoSort data transformation product and the IRI Voracity data management platform.
CoSort's Sort Control Language (SortCL) program allows you to specify new data types and file formats as you:
- integrate and stage large structured data sources in data warehouse ETL operations
- migrate between applications, database, or off the mainframe
- replace slower shell or 3GL programs
- create custom detail, delta, and summary reports
Use SortCL to convert a fixed-length EBCDIC file to a CSV, ASCII, or XML file, while sorting, for example. This consolidated processing saves design steps and run times when offloading and pre-sorting data sets for relational database loads on Unix or Windows servers.
SortCL users can transform data in a variety of ways. Collate (sort), join, aggregate, convert, protect (mask, encrypt, de-identify, etc.), and reformat fields into multiple target output files, tables, and structured reports simultaneously.
Contact IRI to discuss your particular requirements. It is also possible to provide a customized data-type conversion or comparison routine for special data forms.