What's New

What's New in SAS/ACCESS 9.2 for Relational Databases


Overview

SAS/ACCESS 9.2 for Relational Databases has these new features and enhancements:


All Supported SAS/ACCESS Interfaces to Relational Databases

These options are new.

To boost performance when reading large tables, you can set the OBS= option to limit the number of rows that the DBMS returns to SAS across the network.

Implicit pass-through tries to reconstruct the textual representation of a SAS SQL query in database SQL syntax. In the second maintenance release for SAS 9.2, implicit pass-through is significantly improved so that you can pass more SQL code down to the database. These textualization improvements have been made.


DBMS-Specific New Function and Enhancements

SAS/ACCESS Interface to Aster nCluster

SAS/ACCESS Interface to DB2 under UNIX and PC Hosts

SAS/ACCESS Interface to DB2 under z/OS

SAS/ACCESS Interface to Greenplum

SAS/ACCESS Interface to HP Neoview

SAS/ACCESS Interface to Informix

SAS/ACCESS Interface to MySQL

SAS/ACCESS Interface to Netezza

SAS/ACCESS Interface to ODBC

SAS/ACCESS Interface to OLE DB

SAS/ACCESS Interface to Oracle

SAS/ACCESS Interface to Sybase

SAS/ACCESS Interface to Sybase IQ

SAS/ACCESS Interface to Teradata


SAS/ACCESS Interface to Aster nCluster

In the December 2009 release for SAS 9.2, SAS/ACCESS Interface to Aster nCluster is a new database engine that runs on specific UNIX and Windows platforms. SAS/ACCESS Interface to Aster nCluster provides direct, transparent access to Aster nCluster databases through LIBNAME statements and the SQL pass-through facility. You can use various LIBNAME statement options and data set options that the LIBNAME engine supports to control the data that is returned to SAS.

In the third maintenance release for SAS 9.2, this option is new or enhanced:


SAS/ACCESS Interface to DB2 under UNIX and PC Hosts

These options are new or enhanced.

These bulk-load data set options are new:

BLOB and CLOB data types are new.

In the third maintenance release for SAS 9.2, this new feature is available.


SAS/ACCESS Interface to DB2 under z/OS

These options are new or enhanced.

The BLOB and CLOB data types are new.

In the third maintenance release for SAS 9.2, SAS/ACCESS Interface to DB2 under z/OS included many important overall enhancements, such as:

IBM z/OS is the successor to the IBM OS/390 (formerly MVS) operating system. SAS/ACCESS 9.1 and later for z/OS is supported on both OS/390 and z/OS operating systems. Throughout this document, any reference to z/OS also applies to OS/390 unless otherwise stated.


SAS/ACCESS Interface to Greenplum

In the October 2009 release for SAS 9.2, SAS/ACCESS Interface to Greenplum is a new database engine that runs on specific UNIX and Windows platforms. SAS/ACCESS Interface to Greenplum provides direct, transparent access to Greenplum databases through LIBNAME statements and the SQL pass-through facility. You can use various LIBNAME statement options and data set options that the LIBNAME engine supports to control the data that is returned to SAS.


SAS/ACCESS Interface to HP Neoview

You can use the new BULKEXTRACT= LIBNAME and data set options, as well as these new data set options for bulk loading and extracting:


SAS/ACCESS Interface to Informix

These items are new.


SAS/ACCESS Interface to MySQL

The ESCAPE_BACKSLASH= LIBNAME and data set options are new.


SAS/ACCESS Interface to Netezza

The BULKUNLOAD= LIBNAME option is new.

In the third maintenance release for SAS 9.2, you can specify a database other than SASLIB in which to publish the SAS_COMPILEUDF function. If you publish the SAS_COMPILEUDF function to a database other than SASLIB, you must specify that database in the new COMPILEDB argument for the %INDNZ_PUBLISH_FORMATS macro.

In the third maintenance release for SAS 9.2, the SAS_PUT() function supports UNICODE (UTF8) encoding.


SAS/ACCESS Interface to ODBC

These items are new.


SAS/ACCESS Interface to OLE DB

These items are new.


SAS/ACCESS Interface to Oracle

These items are new.


SAS/ACCESS Interface to Sybase

These LIBNAME options are new or enhanced.

Pass-through support is available for new or additional SAS functions, including hyperbolic, trigonometric, and dynamic SQL dictionary functions.


SAS/ACCESS Interface to Sybase IQ

In the December 2009 release for SAS 9.2, SAS/ACCESS Interface to Sybase IQ is a new database engine that runs on specific UNIX and Windows platforms. SAS/ACCESS Interface to Sybase IQ provides direct, transparent access to Sybase IQ databases through LIBNAME statements and the SQL pass-through facility. You can use various LIBNAME statement options and data set options that the LIBNAME engine supports to control the data that is returned to SAS.


SAS/ACCESS Interface to Teradata

These options are new or enhanced.

You can use a new SAS formats publishing macro, %INDTD_PUBLISH_FORMATS, and a new system option, SQLMAPPUTTO, to generate a SAS_PUT() function that enables you to execute PUT function calls inside the Teradata EDW. You can also reference the custom formats that you create by using PROC FORMAT and most of the formats that SAS supplies.

In the second maintenance release for SAS 9.2, this new feature is available.

In the third maintenance release for SAS 9.2, these procedures have been enhanced to run inside the Teradata EDW:

In the third maintenance release for SAS 9.2, the SAS_PUT() function supports UNICODE (UCS2) encoding.


Documentation Enhancements

In addition to information about new and updated features, this edition of SAS/ACCESS for Relational Databases: Reference includes information about these items: