To define new job input
parameters, you will need to carry out the following steps.
||Determine what parameters you will need in the job, what you
need them for, and what data type and length each of them should
||Define an external set to be used as input parameter set.
Instead of computing the elements of the external set on the basis
of a SQL statement, enter them manually. Each element will act as a
job input parameter.
||You can now refer to the input parameter set in SQL statements
(for SQL tasks and import tasks) as if it were a table, and to its
elements as if they were columns.
||When defining the job, enter the name of the input parameter
set in the Input Parameter Set field.
||Optionally, specify a user table to be used for temporary
storage of the external set.
This has the advantage that
you can validate if job input parameters are correct by using
domains, allowed values, mandatory columns, constraints, and
If you use a user-defined table for a parameter set, you have to
provide parameter values with the job. If no parameters are
provided, NULL values are inserted in the user-defined table, which
may result in error messages.
When using a user table, this table is emptied before running