Load Tab

Use the options on the Load tab to set specifications for a load process.

Personal Options dialog, Load tab

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.
Example of the Teradata Settings dialog
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.


Feedback