The direct support for full SQL in an information service activity
provides simplified and flexible access to relational database system capabilities.
This support also includes defining the life cycle management of database
tables using SQL.
Adding SQL snippet
To add SQL statements to business processes, use SQL snippet.
Adding retrieve set
Add retrieve set to load data referenced by a source set reference of type tSetReference into a target business object of type tSet.
Adding atomic SQL sequence
Add atomic SQL sequence to bundle multiple SQL snippets and retrieve sets in a specified order.
Managing the life cycle of a database table
You can bind the lifetime of a database table that is created and used in a process to the lifetime of the process instance that created the table.