Bulk Load

Select this option to enable input on this page.

Corresponding ODBC Parameter: BULKLOAD

Load Options

The load option.

The options are:

RESUME
. Generates a LOAD RESUME statement.
REPLACE
. Generates a LOAD REPLACE statement.

Corresponding ODBC Parameter: LOADOPTIONS, as follows:

RESUME is equivalent to LOADOPTIONS=1.
REPLACE is equivalent to LOADOPTIONS=4.

Delete Temporary Files

Indicates whether to delete temporary files. The options are:

NO.
Temporary files are not deleted.
BEFORE
. Temporary files are deleted before running the loader.
AFTER SUCCESS ONLY
. For a mode type of
JOB
only. Temporary files are deleted after running the loader, if the return code is 0.
AFTER
. For a mode type of
JOB
only. Temporary files are deleted after running the loader.

Corresponding ODBC Parameter: DELETETEMPFILES, as follows:

NO is equivalent to DELETETEMPFILES=1.
BEFORE is equivalent to DELETETEMPFILES=2.
AFTER SUCCESS ONLY is equivalent to DELETETEMPFILES=3.
AFTER is equivalent to DELETETEMPFILES=4.

JCL Template

The name of the JCL file template on the target system, which is a member in a PDS defined on the system where the PowerExchange Listener is running.

Default is DB2LDJCL. You must customize this JCL before using it.

Corresponding ODBC Parameter: JCLTEMPLATE

CTL Template

The name of the DB2 bulk load control file template on the target system, which is a member in a PDS defined on the system where the PowerExchange Listener is running.

If you specify a CTL template, the

Load Options

option is ignored.

Default is DB2LDJCL. You must customize this JCL before using it.

Corresponding ODBC Parameter: CTLTEMPLATE

Mode Type

The mode type. The options are:

JOB
. Submits as a job to the internal reader.
NOSUBMIT
. Not submitted. Instead, creates the DB2 loader-specific control files and data files, saves them on the target system, and generates an executable JCL deck on disk.
TASK
. Submits as a subtask of the PowerExchange Listener.

Corresponding ODBC Parameter: MODETYPE as follows:

TASK is equivalent to MODETYPE=1.
NOSUBMIT is equivalent to MODETYPE=2.
JOB is equivalent to MODETYPE=3.

Mode Time

The mode time. The options are:

WAIT
. Synchronous. For a mode type of
JOB
or
TASK
only. Report the results at end the end of the job or task.
NOWAIT
. Asynchronous. For a mode type of
JOB
or
NOSUBMIT
only. Returns OK when a job is submitted.
TIMED
. Synchronous. For a mode type of
JOB
only. Wait for the specified number of seconds.
DATAONLY
. For all mode types, but typically used with the
NOSUBMIT
mode type. Creates the data DB2 loader file.

Corresponding ODBC Parameter: MODETIME, as follows:

WAIT is equivalent to MODETIME=1.
NOWAIT is equivalent to MODETIME=2.
TIMED is equivalent to MODETIME=3.
DATAONLY is equivalent to MODETIME=4.

Time

Valid only for a mode type of

JOB

and a mode time of

TIMED

.

A value from 0 to 99999, as follows:

0
. No wait.
99999
. Wait.
Any other value. The number of seconds to wait.

Corresponding ODBC Parameter: TIME

Space

The z/OS space allocation. The options are:

TRACK
. Tracks.
CYLINDERS
. Cylinders.

Corresponding ODBC Parameter: SPACE

Primary Space

Amount of primary space for z/OS files.

Corresponding ODBC Parameter: PRISPACE

Secondary Space

Amount of secondary space for z/OS files.

Corresponding ODBC Parameter: SECSPACE

FName

The file name on the host system. Used as the stem for files created on z/OS.

The files created are:

FNAME.DTL
nnnnn
Data for load.
FNAME.DTL
nnnnn
.CTL
Load commands.
FNAME.DTL
nnnnn
.SQL
SQL template - create table.
FNAME.DTL
nnnnn
.SYSPRINT
Output from loader.

Corresponding ODBC Parameter: FNAME