104 INTERFACE= LIBNAME Option Chapter 9
DB2 UNIX/PC Details: You must specify INSERT_SQL=YES in order to use this
option. If one row in the insert buffer fails, all rows in the insert buffer fail. The default
is 1.
ODBC Details: The default is 1.
OLE DB Details: The default is 1.
Oracle Details: The default is 10.
Microsoft SQL Server Details: You must specify INSERT_SQL=YES in order to use
this option. The default is 1.
See Also
To apply this option to an individual data set, see the data set option
“INSERTBUFF= Data Set Option” on page 194.
INTERFACE= LIBNAME Option
Specifies the name and location of the interfaces file that is searched when you connect to the
SYBASE server
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support: SYBASE
Default value: none
Syntax
INTERFACE=<’>file-name<’>
Details
The interfaces file contains names and access information for the available servers on
the network. If you omit a file name, the default action for your operating system occurs.
INTERFACE= is not used in some operating environments. Contact your database
administrator to see whether this statement applies to your computing environment.
KEYSET_SIZE= LIBNAME Option
Specifies the number of rows that are keyset driven
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support:
ODBC, Microsoft SQL Server
Default value: 0
Syntax
KEYSET_SIZE=number-of-rows
