Parameter Sets

Previous Next

See Also

Parameter Sets can be one of two types:

· Input Parameter Sets: these allow you to use the same job more than once but to deal with different data, depending on the variables specified at runtime.


· Output Parameter Sets: jobs can return output parameters. You can define output parameters in an external set.

For example, the Travel Agency wants to produce some statistical reports for different destinations. Rather than writing separate jobs to produce different reports for different destinations, you can write one job, and use a parameter at run time to define the specific destination for the statistical report you want to produce.


In fact, a parameter set is an external set, which describes a temporary table that is used to store the parameters of the job. This table initially contains only one record.