Bateleur Software has extended the capability of CCA’s ADASTRIP data extraction utility by creating eSTRIP. Records that are related by a common key can be extracted to create subsets of data. Once a parent file has been stripped, the child files can be stripped, and related records end up in the same output file. Stripping Process Components

• eSTRIP – Handles the input parameter cards and reads any external data. It then calls ADASTRIP.
• eSTRIPX – An ADASTRIP user exit. An input parameter is supplied to ADASTRIP requesting that the eSTRIP user exit is present.

How Does It Work? eSTRIP reads the parameter cards. These are either stored in memory for later use by eSTRIPX or acted upon by reading, sorting, and creating the in-memory tables. Benefits

• Up to 200 files (an ADASTRIP limitation) can be stripped in a single invocation of eSTRIP, with dependent child files being stripped in a subsequent invocation.
• Values in the sequential file do not need to be pre-sorted, as sorting is performed when the data is loaded into the memory table.
• The ISN (##) can be used as values to be saved or tested against.

Included USER Exits STRIPCSV Converts ADASTRIP output to a comma-separated values (CSV) format. Negative zoned decimal numbers are handled, decimal points can be inserted, and Natural Date and Time fields are converted into an acceptable format. ZONEDEC Resolves issues with negative zoned decimal fields that can cause problems when data is transferred to a different platform. Example Value +123 = F1F2F3 Value –123 = F1F2D3 This is converted to -123 for SQL databases that cannot interpret F1F2D3. STRIPZIP Combines the functionality of ZONEDEC and Zipditto to convert ADASTRIP output into compressed ASCII data in a single, streamlined operation.