Show TOC

Function documentationSQL Transaction Begin

 

You can use this action to begin a logical database transaction.

On executing this action block, the database for the chosen data server is connected from the connection pool. All the query templates under this transaction communicates through this connection.

Features

The parameters for this action are listed in the following table:

Parameter

Input/Output

Type

Description

Server

Input

String

Selects the data server on which the transaction runs.

ConnectionTimeout

Input

Integer

Defines the time in seconds. 0 indicates no timeout.

Success

Output

Boolean

Determines whether the action succeeded or failed.

LastErrorMessage

Output

String

Accessible for debugging and error handling. If the system encounters an error in the configured transaction, the message is returned to this property.

SQLTransaction

Output

String

Name of the begin action block used to map to the input parameter, SQLTransaction in MII SQL Query, MDO Query, and KPI Query.

Activities

You configure this action by defining the SAP data server details on the SAP SQL Query Transaction Support Configuration screen.

To map the linkable parameter, SQLTransaction of the query to the SQLTransaction of the SQL Transaction Begin action block, do the following:.

  1. Create a SQL Transaction Begin action block.

  2. Add a query to the sequence of the SQL Transaction Begin action block.

  3. Right click on the query and choose Links.

  4. Select SQLTransaction from the SQL Transaction Begin action block and map the parameter to the SQLTransaction parameter of the query.