How to Define Job Parameters

Previous Next

See Also

To define a job parameter:

1. Choose Define, Sets, External Sets.

The External Sets window appears.

2. In the Set Name field, type a meaningful name for the parameter set.
3. Click the Elements tab to enter information in the following fields.

In the Sequence Number field, enter 1.

4. In the Element Name field, enter a meaningful name for the parameter (this is the name that will be used in all SQL statements).
5. Click the Data Type lookup button, and choose a data type from the list that appears.
6. In the Data Length field, enter the appropriate length.
7. Optionally, enter a format.