Data Transformation Engine Database Interface Designer Reference Guide

Chapter 5 - Database Sources and Targets Database Connections and Transactions
Database Interface Designer Reference Guide
99
Connection Rules
Existing connections are reused whenever possible while adhering to certain
connection rules. The rules are as follows:
♦ An inactive connection is reused if the database type, connection string, and
user ID of the new card or rule match those of the previous card or rule that
had established the connection.
♦ In addition to the database type, connection string and user ID, an active
connection is reused only if the OnFailure and Transaction > Scope settings
match in the previous card or rule and the new card or rule.
♦ If a card or rule has
-CSTMT set within the adapter’s command, this connection
may be shared with any other card or rule that has
-CSTMT set or that has an
Transaction > Scope setting of Card (or
-CCARD within the adapter’s
command).
♦ If Burst is the SourceRule > FetchAs setting for an active card, it (the card)
is always executed in its own transaction. It establishes a connection that
cannot be shared by any other card for the duration of the map.