Changing run settings for routines

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:

  1. Switch to the Data perspective.
  2. 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.
  3. On the Before Run page, specify SQL statements that you want to run before you run the routine.
  4. 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.
  5. On the After Run page, specify the SQL statements that you want to run after you run the routine.
  6. 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.
  7. Click OK.
The settings are changed and saved.
Related tasks
Running routines

Feedback