The system table SYSLOADER.TRANSFORMATIONSTEPS describes a Loader transformation at table level.
PACKAGEGUID |
CHAR(24) BYTE |
Unique identification of the transformation package |
TRANSFORMATION |
CHAR(32) |
Transformation type (EXPORT | IMPORT | UPDATE) |
OWNER |
CHAR(32) |
Table owner |
SCHEMANAME |
CHAR(32) |
Schema name |
TABLENAME |
CHAR(32) |
Table name |
CATALOGSTREAMNAME |
CHAR(254) |
Name of the CATALOG data stream |
CATALOGSTREAMFORMAT |
CHAR(32) |
Format of the CATALOG data stream (DDL | XML) |
DATASTREAMNAME |
CHAR(254) |
Name of the DATA data stream |
DATASTREAMFORMAT |
CHAR(32) |
Format of the DATA data stream (CSV | DDL | FWV | PAGES | RECORDS) |
DATASTREAMHEADERBLOCK |
FIXED(6,0) |
Start position of the header of the DATA data stream (in 2 GB blocks) |
DATASTREAMHEADERPOS |
FIXED(10,0) |
Start position of the header of the DATA data stream (in bytes, less than 2 GB) |
DATASTREAMDATABLOCK |
FIXED(6,0) |
Start position of the data of the DATA data stream (in 2 GB blocks) |
DATASTREAMDATAPOS |
FIXED(10,0) |
Start position of the data of the DATA data stream (in bytes, less than 2 GB) |
DATASTREAMTRAILERBLOCK |
FIXED(6,0) |
Start position of the trailerof the DATA data stream (in 2 GB blocks) |
DATASTREAMTRAILERPOS |
FIXED(10,0) |
Start position of the trailer of the DATA data stream (in bytes, less than 2 GB) |
RESTART |
BOOLEAN |
Transformation step was executed (TRUE) or not (FALSE) |
START |
FIXED(10,0) |
Number of transformed rows |