DB_ONE_CONNECT_PER_THREAD= Data Set Option

Specifies whether to limit the number of connections to the DBMS server for a threaded Read.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: YES
Data source: Oracle
See: Autopartitioning Scheme for Oracle

Syntax

DB_ONE_CONNECT_PER_THREAD=YES | NO

Syntax Description

YES
enables this option, allowing only one connection per partition.
NO
disables this option.

Details

Use this option if you want to have only one connection per partition. By default, the number of connections is limited to the maximum number of allowed threads. If the value of the maximum number of allowed threads is less than the number of partitions on the table, a single connection reads multiple partitions.