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 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 setting of Card (or -CCARD within the adapter's command).
- If Burst is the 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.