The system table TRANSFORMATIONRESOURCES describes the data sources and data targets involved in a Loader transformation.
TRANSFORMATIONRESOURCES
PACKAGEGUID |
CHAR(24) BYTE |
Unique ID of the transformation package |
SERVERNODE |
CHAR(32) |
Computer node on which the database instance to be transformed is installed |
SERVERDB |
CHAR(32) |
Name of the database instance that is to be transformed |
USERNAME |
CHAR(32) |
User name |
CODEPAGEID |
CHAR(32) |
ID of the ASCII code page that is to be used |
STORAGEDEVICE |
CHAR(32) |
External data carrier that is to be used |
CATALOGSTREAMNAME |
CHAR(254) |
Name of the CATALOG data stream |
CATALOGSTREAMTYPE |
CHAR(32) |
Data carrier of the CATALOG data stream (FILE | PIPE | TAPE) |
CATALOGSTREAMEBID |
CHAR(32) |
External backup ID of the CATALOG data stream |
DATASTREAMNAME |
CHAR(254) |
Name of the DATA data stream |
DATASTREAMTYPE |
CHAR(32) |
Data carrier of the DATA data stream (FILE | PIPE | TAPE) |
DATASTREAMEBID |
CHAR(32) |
External backup ID of the DATA data stream |
See also:
Additional System Tables