Use Multiple Statements

UseMultipleStatements

Key Name	Default Value	Required
UseMultipleStatements	Disabled (0)0	No

Description

This option specifies whether the connector can have more than one query, separated by a semicolon ( ; ), in a single SQLExecDirect call.

• Enabled (1)1: The connector can have more than one query, separated by semicolon ( ; ), in a single SQLExecDirect call. The connector returns all the query results into memory.
• Disabled (0)0: The connector executes one query at a time in SQLExecDirect.

When using connection attributes to set connector options, make note of the following:

• If UseDeclareFetch is set to 1, then it takes precedence over UseMultipleStatements.
• If UseDeclareFetch is set to 0 and SingleRowMode is set to 1, then SingleRowMode takes precedence over UseMultipleStatements.

Related topics

• Retrieve Entire Result Into Memory
• Single Row Mode
• Use Declare/Fetch
• Advanced Driver Configuration Options on page 1
• Query Processing Modes
• Configuring Additional Options
• Configuring Query Processing Modes
• Using a Connection String