Load tab

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

Example of the Load tab on the Personal Options dialog, described as follows.

Load Specifications

Provide the complete path and name of the executable to access each DBMS 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.

Exception Table Default Creator ID
Provide a default Creator ID for exception tables (DB2® and Oracle) or violation tables (Informix®). This field is available only when you select a DB Alias for a DB2, Oracle, or Informix database.
Fully Qualified Path for DBMS Loaders
Provide 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 z/OS® FTP server, used when files are uploaded to the z/OS machine during the Load Process. This option is available when you select the (Default) or a DB2 DB Alias. You can override the user ID in the Load Request.
z/OS FTP Password
Provide the password for the default z/OS FTP server user ID. This option is available when you select the (Default) or a DB2 DB Alias. You can override the password in the Load Request.
Teradata
Select to provide settings for the Teradata loader. This option is available when you select a DB2 DB Alias for a Teradata database. The Teradata Settings dialog displays.
Example of the Teradata Settings dialog, where you specify values for loading files to a Teradata database.
Use FastLoad if more rows than
Row count to determine whether FastLoad or MultiLoad is used. Allowable values are 0-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 Use FastLoad if more rows than.
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.
Server Name
Name of the Teradata server.
Teradata User ID
Teradata user ID for the user that is creating the Load Request.
Teradata Password
Teradata password for the user that is creating the Load Request.
DB2i
Select to provide settings for the DB2 for i loader. This option is available when you select a DB2 DB Alias for a DB2 for i database. When you click DB2i, the DB2i Loader Settings dialog is displayed.
Example of the DB2i Loader Settings dialog, where you specify values for loading files to a DB2 for i database.
Enter the connection string for the DB2 for i database and the user ID and password to use to access the DB2 for i database.