Use Declare/Fetch

UseDeclareFetch

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

Description

This option specifies whether the connector uses Declare/Fetch Mode and returns a specific number of rows at a time.

• Enabled (1)1: The connector uses Declare/Fetch Mode and returns a specific number of rows at a time. To specify the number of rows, configure the Cache Size option (the Fetch attribute).
• Disabled (0)0: The connector returns all rows at once.

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

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

Related topics

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