SQL 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:.

Create a SQL Transaction Begin action block.
Add a query to the sequence of the SQL Transaction Begin action block.
Right click on the query and choose Links.
Select SQLTransaction from the SQL Transaction Begin action block and map the parameter to the SQLTransaction parameter of the query.