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:
- Data files — Data files contain the data
you want to load, prepared in the format appropriate for the DBMS
you are using. Optim™ generates
a data file for each table in the Archive or Extract File. Data files
are named the same as the Archive or Extract File, but contain sequentially
numbered file name extensions. For example, an Extract File named demo.xf that
contains three tables will generate three data files named: demo.001, demo.002,
and demo.003.
- Message files — Message files contain information
that the database load utility generates during the Load Process.
Typically, there is one message file for the entire Load Process.
The message file is named the same as the Archive or Extract File,
but contains the extension .msg. For example, if the Extract
File is named demo.xf, the message file is named demo.msg.
- For DB2®, an SQL
file is generated with one statement for each destination table
that contains the loader syntax to manually execute the loader. The
SQL file is named the same as the Archive or Extract file, but has
the extension .sql.
- For Oracle, Sybase ASE, SQL Server, and Informix®, a BAT file is
generated that contains the syntax to manually execute the loader
for each table. A BAT file is generated for each DB Alias specified
in the Table Map. Each BAT file resides in the directory with the
corresponding converted Load file. If you chose to manually execute
the loader, the BAT file must be edited (in Notepad, for example)
to replace a string of eight question marks with specific password
information (except Informix).
Additionally, a Format file is generated for
each data file. A format file has the same name as the corresponding
data file, except that the file name extension is different. If there
are less than 500 tables to load, the format file name extension is
500 greater numerically than the data file name extension. (For example,
if there are three data files named demo.001, demo.002,
and demo.003, the corresponding format files are named demo.501, demo.502 and demo.503,
respectively.) If there are more than five hundred tables, a more
complex file extension generation algorithm is employed.
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.