Use the Load tab to specify the
paths to DBMS loaders.
Note: You can expedite the configuration of the Load settings
for the Server by clicking Merge Current User.
This merges Load settings for the logged-on user in the Current User
registry with settings for the Server machine in the Local Machine
registry.
Optim Directory
Select [Default] in the Optim Directory list
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. Select the specific Optim™ Directory
and DB Alias, then enter the appropriate path and name of the Loader
executable file for the particular DBMS version.
Load Specifications
Specify
the complete path and name of the executable to access each DBMS Loader
that can be used with a Load Request.
- DB Alias
- Select a specific Optim Directory,
then click the down arrow to select a specific DB Alias. Specify the
appropriate loader path for the corresponding DBMS version.
If you are using DB2®,
Oracle, or Informix®, you
can also specify a default Creator ID for Exception Tables (or Violation
Tables).
To specify load settings for a Teradata database, select
a Teradata-related 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. This parameters is available only when you select a DB Alias
for a DB2, Informix, Oracle, or Teradata database.
- Fully Qualified Path for DBMS Loaders
- 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.
- Teradata
- Click to provide settings for the Teradata loader on the Teradata
Settings dialog.
- Use FastLoad if more rows than:
- Type 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 of the load file is greater than the value
you specify for this parameter.
- Fully qualified path for Teradata FastLoad
- Provide the directory path and program name for the 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
- Provide the directory path and program name for the 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
- Type the name of the Teradata server.
- Teradata User ID
- Type the Teradata User ID for the user creating the Load Request.
- Teradata Password
- Type the Teradata password for the user creating the Load Request.
Merge Current User
Click Merge
Current User to merge the settings from the Current User
registry to the Local Machine registry for the Server machine.