Changing run settings for SQL or Java routines

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:

  1. 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.
  2. On the Before Run page, specify SQL statements that you want to run before you run the routine.
  3. 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.
  4. On the After Run page, specify the SQL statements that you want to run after you run the routine.
  5. 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.
  6. Click OK.

Results

The settings are changed and saved.

Feedback