Skip to main content

Specifying Other Runtime Settings

Specifying Other Runtime Settings

The SQL business operation provides the following additional runtime settings:

Credentials

ID of the production credentials that can authorize a connection to the given DSN. For information on creating production credentials, see Configuring Productions.

StayConnected

Specifies whether to keep the connection open between commands, such as issuing an SQL statement or changing an ODBC driver setting.

  • If this setting is 0, the SQL outbound adapter disconnects immediately after each command.

  • If this setting is positive, it specifies the idle time, in seconds, after the command completes. The adapter disconnects after this idle time.

  • If this setting is –1, the adapter auto-connects on startup and then stays connected.

If you are managing database transactions as described in Managing Transactions, do not set StayConnected to 0.

For any settings not listed here, see Configuring Productions.

FeedbackOpens in a new tab