Specifies whether operations on a single libref can share a connection to the DBMS.
Valid in: | LIBNAME statement |
Default: | SHAREDREAD |
Supports: | DB2 under UNIX and PC, Greenplum, MySQL, ODBC, Oracle, Teradata |
specifies that all operations that access DBMS tables in a single libref share a single connection.
specifies that all Read operations that access DBMS tables in a single libref share a single connection. A separate connection is established for every table that is opened for update or output operations.
specifies that a separate connection is established every time a DBMS table is accessed by your SAS application.