Use the options on the Load tab
to set specifications for a Load Process.
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 uploading files 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 panel displays:
- 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 creating the Load Request.
- Teradata Password
- Teradata password for the user creating the Load Request.