Search

Bulk Data Movement Guide

Bulk Data Movement Guide

10.5.4
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Substitution Variables in the Loader JCL Templates

Substitution Variables in the Loader JCL Templates

The JCL templates DB2LDJCL, and DB2LDJCP include substitution variables. Before submitting a job to z/OS, PowerExchange resolves the defined substitution variables with the appropriate values.

The following table describes these variables:

Variable	Description
%ENDJOB	16-character input string for DTLNTS. Enables the PowerExchange Listener to determine if the job has ended.
%JOBCLASS	Substituted for the job class specified in the loader parameters.
%JOBFILE	Substituted for the name of the file that contains the JCL skeleton used to build the job.
%N`n`	Substitutes an incrementing number of 1 to 7 significant digits.
%PARTDDN	Generates the DDNAME for the input data for a partition. Has the form PAR`nnnn`, where `nnnn` represents the partition number. The skeleton JCL can contain multiple instances of this variable. Unused instances are set to PRTnnnn.
%PN`n`	Substitutes a partition number of 1 to 4 significant digits only if the load is for a partitioned table. Do not use with a load JCL skeleton for a non-partitioned table.
%PWD	Specifies the password or passphrase in the JOB statement. PowerExchange uses this password or passphrase when the PowerExchange Listener runs at security level 2 and the Db2 LOAD job runs with different credentials than the PowerExchange Listener job. z/OS does not display the password or passphrase. The template must define %PWD as the last part of the JOB statement and it must be on a separate line that contains the following specification: // PASSWORD=%PWD For more information, see the PowerExchange Reference Manual .
%SSID	DB2 subsystem ID of the load target.
%STRTJOB	16-character input string for DTLNTS. Enables the PowerExchange Listener to determine if the job has started.
%SYSDISC	Substitutes the name of the file to which discarded records are written.
%SYSIN	Substitutes the name of the file containing the loader control statements.
%SYSPRINT	Substitutes the name of the file to which the loader messages are written.
%SYSREC	Substitutes the DSNAME for the input data. For unused instances in a partitioned load, this value is set to NULLFILE.
%USER	User ID.
%UID	Specifies the user ID in the JOB statement. PowerExchange uses this user ID when the PowerExchange Listener runs at security level 2 and the Db2 LOAD job runs with different credentials than the PowerExchange Listener job.

Using the DB2 LOAD Utility to Load Bulk Data

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.