Using the load process on a distributed platform

Use the Load Process to transform the contents of an Archive or Extract File into a format that is appropriate for a particular DBMS loader and then, if specified, start the corresponding database load utility.

The Load Process generates a data file in the correct format for each table in the Archive or Extract File and an SQL file or a BAT file (Batch Execution), depending on the DBMS, that contains the syntax necessary to start the database loader.

A Load Request contains the parameters used to prepare data for a DBMS loader and the instructions required to process the load. Specify a Table Map in the Load Request to map the destination for the data to load. Use optional Column Maps in the Load Request to transform data before loading. For details, see the Common Elements Manual.

Data to be loaded must be contained in an Archive or Extract File. You can use the Archive or Extract Process to create the corresponding file, or use an existing Archive or Extract File. See Extract Process.

Process File Names

The Load Process generates the following types of files to support the database utility load process:

Note: If your file server does not allow long file names of greater than 8 characters and the Archive or Extract File has a long name, the Load Process will fail. The best solution is to avoid using long file names for Archive or Extract Files. If needed, you can copy and rename a file before you use it for a Load Process.