This action executes a query on a database defined by the designated database transaction. The query text can be explicitly entered or read from a file. If desired, the results of the database query can be placed in a Shared Property.
For this action to be valid, the transaction name must be defined and this action must follow a Begin Database Transaction with a matching transaction name. Query text or a query file must also be specified.
Prepare Stage
No action taken.
Execute Stage
Backs up the previous output property, if needed.
Runs the specified query on the defined database transaction.
Cleanup Stage
No action taken.
Rollback Stage
Restores the previous output property value, if needed.