The system table TRANSFORMATIONSTEPS describes a Loader transformation at table level.
TRANSFORMATIONSTEPS
PACKAGEGUID |
CHAR(24) BYTE |
Unique ID of the transformation package |
TRANSFORMATION |
FIXED(6.0) |
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 trailer of 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 |
See also:
Additional System Tables