SAS/ACCESS Software

SAS/ACCESS Software for Relational Databases

The following changes and enhancements have been made to all of the SAS/ACCESS interfaces to relational databases:

A new system option, DBSRVTP=, enables you to improve SAS server throughput by specifying whether certain SAS/ACCESS engines put a hold (or block) on the originating client while making performance-critical calls to the database. This option applies when SAS is invoked as a server that is responding to multiple clients.
The LIBNAME option PRESERVE_COLUMN_NAMES= now applies only to table creation. This option is now also available as a data set option.
SAS/ACCESS can now convert many SAS functions into the SQL of the DBMS, which improves performance by causing the functions to be processed by the DBMS. This enhancement is available for WHERE clauses and PROC SQL when you use the SAS/ACCESS LIBNAME statement.

Bulk loading, which uses the DB2 LOAD utility to enable you to rapidly load rows into a DB2 table, is now supported.

The BIGINT numeric data type, which specifies a big integer, is now supported. Values in a column of this type can range from -9223372036854775808 to +9223372036854775807.
A new LIBNAME and data set option, INSERTBUFF=, specifies the number of rows in a single DBMS insert.

A new LIBNAME and data set option, UPDATE SQL=, determines which method is used to update and delete rows in a data source.
A new LIBNAME and data set option, INSERTBUFF=, specifies how many rows are included in a single DBMS insert.
The BIGINT numeric data type, which specifies a big integer, is now supported. Values in a column of this type can range from -9223372036854775808 to +9223372036854775807.
SAS/ACCESS can now pass outer joins between two or more tables, with certain restrictions.

A new LIBNAME and data set option, UPDATE SQL=, determines which method is used to update and delete rows in a data source.
A new LIBNAME and data set option, INSERTBUFF=, specifies how many rows are included in a single DBMS insert.
SAS/ACCESS can now pass outer joins between two or more tables, with certain restrictions.
The BIGINT numeric data type, which specifies a big integer, is now supported. Values in a column of this type can range from -9223372036854775808 to +9223372036854775807.

The Microsoft Data Link API is supported through a new LIBNAME engine connection option, UDL_FILE=.

SAS/ACCESS can now pass outer joins between two or more tables.

SAS/ACCESS can now pass outer joins between two or more tables, with certain restrictions.

The TIME and TIMESTAMP date/time data types are now supported.