
The system table SYSLOADER.TRANSFORMATIONPACKAGES contains all steps of a Loader transformation for a transformation package.
|
PACKAGEGUID |
CHAR(24) BYTE |
Unique identification of the transformation package |
|
TASKID |
FIXED(6,0) |
Identification of the transformation task |
|
STEPID |
FIXED(6,0) |
Identification of the transformation step |
|
OWNER |
CHAR(32) |
Table owner |
|
SCHEMANAME |
CHAR(32) |
Schema name |
|
TABLENAME |
CHAR(32) |
Table name |
|
EXCLUDE |
BOOLEAN |
Transformation step was excluded (TRUE) or not (FALSE) |
|
RESTART |
BOOLEAN |
Transformation step was executed (TRUE) or not (FALSE) |