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.
Restriction:
To change the settings for running
a SQL or Java 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.