TRANSFORMATIONRESOURCES

Definition

The system table TRANSFORMATIONRESOURCES describes the data sources and data targets involved in a Loader transformation.

Structure

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