Object documentationLoader System Tables Locate this document in the navigation structure

 

An important log function of the Loader is to store Loader-relevant information in system tables.

 

When the database system is installed, the following system tables are created for Loader:

SYSLOADER System Tables

CODEPAGE

MAPSCHEMANAMES

TRANSFORMATIONMODEL

TRANSFORMATIONMONITOR

TRANSFORMATIONPACKAGES

TRANSFORMATIONRESOURCES

TRANSFORMATIONSTATISTICS

TRANSFORMATIONSTEPS

The database system administrator is the owner of these system tables. The tables are generated in the SYSLOADER schema. You need to specify the schema to access these tables.

Loader logs information on the runtime responses of export and import processes in the TRANSFORMATION* system tables. You can also configure a transformation using the system tables. Loader uses the entries in the system tables to restart commands. You can use the RESTART option of the Loader command for this restart.

Example

Example Example

SELECT * FROM sysloader.transformationmodel

WHERE PACKAGEGUID = <package_guid>

End of the example.

More Information

Restarting

Additional Log Functions (package_spec)

Loader Commands and SQL Statements

Loader Log Functions