Job Input Parameters

Input parameters enable you to run the same job more than once, but dealing with different data, depending on the parameters specified at run time. You define input parameters in an external set. When running the job, a table is used to represent the external set. This table can either be a table in memory, a user-defined table, or a table defined in the Definer. Each column of this table corresponds to one parameter that is passed to the job.

When a job is started, first the corresponding table is emptied, and then one initial record with all input parameters is inserted into the table. The input set can be used as if it were a database table throughout the job.