A SERVICE OF

logo

The LIBNAME Statement for Relational Databases MAX_CONNECTS= LIBNAME Option 107
Default value: none
Syntax
LOCKTIME=integer
Details
You must specify LOCKWAIT=YES for LOCKTIME= to have an effect. If you omit the
LOCKTIME= option and use LOCKWAIT=YES, SAS suspends your process indefinitely
until a lock can be obtained.
See Also
“LOCKWAIT= LIBNAME Option” on page 107
LOCKWAIT= LIBNAME Option
Specifies whether to wait indefinitely until rows are available for locking
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support:
Informix, Oracle
Default value:
DBMS-specific
Syntax
LOCKWAIT= YES | NO
Syntax Description
YES
specifies that SAS waits until rows are available for locking.
NO
specifies that SAS does not wait and returns an error to indicate that the lock is not
available.
MAX_CONNECTS= LIBNAME Option
Specifies the maximum number of simultaneous connections that SYBASE allows
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support: SYBASE