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:
- Drop an information service activity from the sub palette on the
canvas. Enter the display name, the name,
and a description.
- Click the Details tab in the properties
area and select atomic SQL sequence from the list showing the different kinds
of information services.
- 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

.