Adding process instance settings

You can add data definition language (DDL) statements that perform preparation tasks when a process instance starts and cleanup statements when the process instance is removed.

For example, at process instance start time you might want to create a new view of a table, or refill a table.

Conversely, DDL statements performing cleanup tasks can be run when the process instance is removed, for example, statements that drop the tables created when the instance starts.

To add process instance settings:

  1. Click the canvas to see the process related properties.
  2. Click the Information Service Support tab in the properties area.
  3. Click the Process Start Time tab.
  4. Add a new data source.
    1. Enter the display name and the Java™ naming and directory interface (JNDI) name.
    2. Select Preparation or Cleanup statement under the new data source and click New Statement to enter your own SQL statement in the editor.

(C) Copyright IBM Corporation 2006. All Rights Reserved.