TRANSFORMATIONSTEPS

Definition

The system table TRANSFORMATIONSTEPS describes a Loader transformation at table level.

Structure

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