The LIBNAME Statement for Relational Databases IN= LIBNAME Option 101
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support:
SYBASE
Default value:
YES
Syntax
ENABLE_BULK=YES | NO
Syntax Description
NO
disables the bulk copy ability for the libref.
YES
enables the connection to perform a bulk copy of SAS data into SYBASE.
Details
Bulk copy groups rows so that they are inserted as a unit into the SYBASE table.
Using bulk copy can improve performance.
If you use both the LIBNAME option, ENABLE_BULK=, and the data set option,
BULKLOAD=, the values of the two options must be the same or an error is returned.
However, since the default value of ENABLE_BULK= is YES, you do not have to
specify ENABLE_BULK= in order to use the BULKLOAD= data set option.
Note: In Version 7 and previous releases, this option was called BULKCOPY=. In
Version 8, an error is returned if you specify BULKCOPY=.
IN= LIBNAME Option
Enables you to specify the database and tablespace in which you want to create a new table
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support: DB2 OS/390, DB2 UNIX/PC
Default value:
none
Syntax
IN=’database-name.tablespace-name’| ’DATABASE database-name’
Syntax Description
database-name.tablespace-name
specifies the names of the database and tablespace, which are separated by a period.
Enclose the entire specification in single quotation marks.
DATABASE database-name
