Adding atomic SQL sequence

Add atomic SQL sequence to bundle multiple SQL snippets and retrieve sets in a specified order.

Atomic SQL sequence implies that all SQL snippets and retrieve sets in the sequence are processed in a single transaction even if your process is long running.

To add atomic SQL sequence to your business process:

  1. Drop an information service activity from the sub palette on the canvas. Enter the display name, the name, and a description.
  2. Click the Details tab in the properties area and select atomic SQL sequence from the list showing the different kinds of information services.
  3. Select New to add and define either SQL snippets or retrieve sets.
You can identify an atomic SQL sequence in your business process flow by its icon Atomic SQL sequence icon.

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