Show TOC

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:

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

SELECT * FROM sysloader.transformationmodel

WHERE PACKAGEGUID = <package_guid>

End of the example.