You can change the settings that are used when you run
a SQL or Java routine on the database server. For example, you can
specify SQL statements that you want to run before and after you run
the routine.
Procedure
To change the settings for running a SQL or Java routine
on the database server:
- 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.
Results
The settings are changed and saved.