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

SAS/ACCESS 9.2 for Relational Databases has the following changes and enhancements:

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

• SAS/ACCESS supports additional hosts for existing DBMSs.

These items are new:

• AUTHDOMAIN= LIBNAME option

• DBIDIRECTEXEC= system option

• brief trace capability (',,,db' flag) on the SASTRACE= system option

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.

The SQL_FUNCTIONS_COPY= LIBNAME option is new.

The following LIBNAME options are enhanced:

• SQL_FUNCTIONS=

• automatically calculated INSERTBUFF= and READBUFF= for use with pass-through

• changed default values for CURSOR_TYPE= and UTILCONN_TRANSIENT=

The following bulk-load data set options are new:

• BL_ALLOW_READ_ACCESS=

• BL_ALLOW_WRITE_ACCESS=

• BL_CPU_PARALLELISM=

• BL_DATA_BUFFER_SIZE=

• BL_DISK_PARALLELISM=

• BL_EXCEPTION=

• BL_PORT_MAX=

• BL_PORT_MIN=

The following macro variables and system options are new or enhanced:

• new bulk-loading macro variables

• improved debugging capabilities for the SASTRACE= system option

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

z/OS is the successor to the 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.

The following items are new:

• SQL_FUNCTIONS_COPY= LIBNAME option

• LOCATION connection option, LIBNAME option, and data set option

• DEGREE= data set option

The SQL_FUNCTIONS= LIBNAME option is enhanced.

The DB2CATALOG= system option is new.

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

The following items are new:

• AUTOCOMMIT= LIBNAME option

• GLOBAL and SHARED options for the CONNECTION= LIBNAME option

• DBSASTYPE= data set option

• DBDATASRC environmental variable

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

• DATEPART and TIMEPART SAS functions

• support for special characters in naming conventions

The following items are new:

• SQL_FUNCTIONS= and SQL_FUNCTIONS_COPY= LIBNAME options

• ESCAPE_BACKSLASH= LIBNAME and data set options

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

The following LIBNAME options are new or enhanced:

• BULKUNLOAD=

• SQL_FUNCTIONS= and SQL_FUNCTIONS_COPY=

The following items are new:

• SQL_FUNCTIONS_COPY= LIBNAME option

• LOGIN_TIMEOUT= LIBNAME option

• READBUFF= data set option, LIBNAME option, and pass-through support for improved performance

The SQL_FUNCTIONS= LIBNAME option has been enhanced.

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

The following items are new:

• GLOBAL and SHARED options for the CONNECTION= LIBNAME option

• BULKLOAD= data set option

• DATATYPE=GUID input data type

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

The following items are new:

• ADJUST_BYTE_SEMANTIC_COLUMN_LENGTHS=,  ADJUST_NCHAR_COLUMN_LENGTHS=, DBCLIENT_MAX_BYTES=, and DBSERVER_MAX_BYTES= LIBNAME options

• BL_USE_PIPE= data set option

• GLOBAL and SHARED options for the CONNECTION= LIBNAME option

• OR_ENABLE_INTERRUPT= LIBNAME option

• function and default value for SHOW_SYNONYMS= LIBNAME option

• SQL_FUNCTIONS= and SQL_FUNCTIONS_COPY= LIBNAME options

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

The following items are new:

• SQL_FUNCTIONS_COPY= LIBNAME option

• GLOBAL and SHARED options for the CONNECTION= LIBNAME option

The SQL_FUNCTIONS= LIBNAME option has been enhanced.

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

The following items are new:

• SQL_FUNCTIONS= and SQL_FUNCTIONS_COPY= LIBNAME options

• GLOBAL and SHARED options for the CONNECTION= LIBNAME option

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

Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.