Single Row Mode

SingleRowMode

Key Name	Default Value	Required
SingleRowMode	Clear (0)0	No

Description

This option specifies whether the connector uses Single Row Mode and returns query results one row at a time. Enable this option if you plan to query large results and do not want to retrieve the entire result into memory.

• Enabled (1)1: The connector returns query results one row at a time.
• Disabled (0)0: The connector returns all query results at once.

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

• If SingleRowMode and UseDeclareFetch are both set to 0, then the connector retrieves the entire query result into memory.
• If UseDeclareFetch is set to 1, then it takes precedence over SingleRowMode.
• If SingleRowMode is set to 1 and UseDeclareFetch is set to 0, then SingleRowMode takes precedence over UseMultipleStatements.

Related topics

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