Bulk Data Movement Guide

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

Back Next

Substitution Variables in the Loader JCL Templates

The JCL and control card templates DB2LDCTL, DB2LDCTP, DB2LDJCL, and DB2LDJCP include substitution variables. Prior to 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	Password. Will appear in the plaintext in the job.
%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.
%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.

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

Substitution Variables in the Loader JCL Templates

Substitution Variables in the Loader JCL Templates