The SQL Transaction builder chains together other SQL builders in the model to create a transaction sequence.
Once you have composed a query and provided transformation information, you can build an entire transaction. This builder can create either a short-lived or a long-lived SQL transaction. Such a transaction might identify a datasource, the SQL statement to execute, and a transform to apply to the ResultSet. When running an SQL statement against a database, you can track statement-related database events in the model and also generate statistics and logs related to a statement execution. These options allow you to assess performance and maintain an audit trail of statement usage. If the SQL statement returns data, you can use a Data Page builder to display it.
Parent topic: Building an SQL statement