The documentation portal is undergoing maintenance. During this period, you can't create any new user credentials. If you do, you'll need to recreate the user credential after the maintenance period ends.
wizard, enter the properties to define PowerExchange for DB2 bulk load processing.
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.