Single Row Mode

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): The connector returns query results one row at a time.
  • Disabled (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.
Key Name Default Value Required

SingleRowMode

Clear (0)

No