The tableBASE ETL (Extract, Transform, Load) interface is a batch utility that loads data from external sources directly into tableBASE tables. It supports two data source types: DB2 and VSAM. A single ETL run can process multiple tables for each source, DB2 or VSAM, with each table able to target a different storage destination. The data will be loaded in either a tableBASE library, a table in a VTS-TSR, or both.
For DB2 sources, reads two pre-generated files produced by the DB2 Unload Utility: a Punch File containing the source table layout, and a Record File containing the unloaded data.
When a table is loaded, any data previously stored in the target tableBASE table is fully replaced by the newly loaded data. ETL maintains a processing log throughout the run. When processing multiple tables in a single run, if an error occurs on one table, ETL skips to the next table and continues until all entries have been attempted.
Optionally, ETL can generate a COBOL copybook describing the row layout of each loaded tableBASE table, based on the parameters defined in the mapping dataset. For VSAM source ETL can handle three types of files: RRDS, KSDS, and ESDS. LDS is not supported.