Data Set Options for Relational Databases

DB_ONE_CONNECT_PER_THREAD= Data Set Option

Specifies whether to limit the number of connections to the DBMS server for a threaded read.

Default value:	YES
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	Oracle

Syntax
Syntax Description
Details
See Also

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.