Use the options on the Load tab
to set specifications for a load process.
Load Specifications
Specify the complete path and name of the executable
to access each loader that can be used with a load request.
- DB Alias
- Select [Default] to enter the path
and name of the loader executable file for each DBMS type. If you
have more than one version of a particular DBMS type, you can enter
the unique loader specification for each version. Click the down arrow
to select the specific DB alias, then enter the appropriate path and
name of the Loader executable file for the particular DBMS version.
To specify load settings for a Teradata database, select a Teradata
DB Alias and click the Teradata button to display
the Teradata Settings dialog.
- Exception Table Default Creator
ID
- Specify a default creator
ID or other identifier for exception tables for DB2® and Oracle, violation tables for Informix®, or error tables and
work tables for Teradata. For Teradata, this parameter is used to
specify the database name in Teradata in which the error tables and
work tables (temporary tables) can be created by the Teradata loaders.
- Fully Qualified Path for DBMS Loader
- Specify the directory path and program
name for the specific DBMS loader. Consult your DBMS documentation
for the name of the loader program. To select from your system directories,
click the browse button.
- z/OS® FTP User ID
- Provide the default user ID for the DB2 for z/OS FTP server, used when uploading
files during the load process. This option is available when you select
the (Default) or a DB alias for DB2. You can override the user ID in the load request.
- z/OS FTP Password
- Provide the password for the default user ID for
the FTP server . This option is available when you select the (Default)
or a DB Alias for DB2 . You
can override the password in the load request.
- Teradata
- Click to provide settings for the Teradata loader on the Teradata Settings dialog. This option is available in
- Optim v8.1 and higher if you are using Optim
native support for a Teradata database, and
- Optim v7.3.1 if you specified a DB2 DB Alias for a Teradata
database.
- Use FastLoad if more rows than
- The row count used to determine whether FastLoad or MultiLoad
is used. Allowable values are 0 to 999,999,999. If you specify 0 or
do not specify a value, MultiLoad is used. For any other value, FastLoad
is used if the row count in the load file is greater than the value
you specify for this parameter.
- Fully qualified path for Teradata FastLoad
- The directory path and program name for Teradata FastLoad. Consult
your Teradata documentation for the name of the loader program. To
select from your system directories, click the browse button.
- Fully qualified path for Teradata MultiLoad
- The directory path and program name for Teradata MultiLoad. Consult
your Teradata documentation for the name of the loader program. To
select from your system directories, click the browse button.
- Fully qualified path for Basic Teradata Query
facility
- Provide the directory path and program name for the Basic Teradata
Query facility (BTEQ). Consult your Teradata documentation for the
name of this facility. To select from your system directories, click
the browse button.
- Server Name
- The name of the Teradata server.
- Teradata User ID
- The Teradata user ID for the user creating the load request.
- Teradata Password
- The Teradata password for the user creating the load request.