You can change
the settings that are used when you run a routine
on the database server. For example, you can specify SQL statements
that you
want to run before and after you run the routine.
To change the settings for running a routine
on the database server:
- Switch to the
Data perspective.
- In either the Data Source
Explorer or the Data Project Explorer,
right-click the routine that you want to run, and click Run
Settings. You must select a routine that has
been deployed to a database. The Run Settings window
opens.
- On the Before Run page, specify
SQL statements that you want to
run before you run the routine.
- On the Parameter
Values page, specify the parameters that you want
to use for running the routine. If a parameter requires
a string
value, type the value without string delimiters. If the parameter
requires
binary input, enter the hex string without delimiters.
- On the After Run page, specify the SQL statements that
you want
to run after you run the routine.
- On the Options
page, select whether you want to commit changes
to the database, and for DB2® for z/OS®,
specify the collection ID that you want to use. If you
do not select to commit changes to the database, any changes
that are made as a result of running the routine are rolled back.
- Click OK.
The settings are changed and saved.