Object documentationTRANSFORMATIONSTEPS Locate this document in the navigation structure

 

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

Structure

TRANSFORMATIONSTEPS

PACKAGEGUID

CHAR(24) BYTE

Unique identification of the transformation package

TRANSFORMATION

CHAR(32)

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 trailerof 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