Retrieve Entire Result Into Memory
| Key Name | Default Value | Required |
|---|---|---|
|
N/A |
|
No |
Description
This option specifies whether the connector returns the entire query result into memory.
-
1)1: The connector returns the entire query result into memory. -
0)0: The connector returns the query result in chunks or single rows.
When using keys to set connector options, you can enable this option by setting the SingleRowMode, UseDeclareFetch, and UseMultipleStatements keys to 0.
Note:
When using connection attributes to set connector options, you can enable this option by setting the SingleRowMode, UseDeclareFetch, and UseMultipleStatements attributes to 0.
- Single Row Mode
- Use Declare/Fetch
- Advanced Driver Configuration Options on page 1
- Query Processing Modes
- Configuring Additional Options
- Configuring Query Processing Modes
-