Two new 'Special Queries' were added to SAS/ACCESS Interface to ODBC and
SAS/ACCESS Interface to DB2.
 
1. SQLDataSources: This will return a list of datasources
     For ODBC it returns:  Data_Source_Name (list of ODBC DSNs)
                           Description
     For DB2 it returns:   Database
                           Description
 
   For example:
      proc sql;
      connect to odbc(prompt);
      select * from connection to odbc(ODBC::SQLDataSources());
      quit;
 
  NOTE: For DB2, you call DB2::SQLDataSources
 
2. SQLDBMSInfo:  This will return 2 variables
        Server:  Information about the server, such as the server type
       Version:  Version of the server
 
   For example:
      proc sql;
      connect to odbc(prompt);
      select * from connection to odbc(ODBC::SQLDBMSInfo());
      quit;
 
   NOTE: For DB2, you call DB2::SQLDBMSInfo
 
We have patches that can be downloaded from:
 
V8.2 SAS/ACCESS to DB2:
A Technical Support hot fix for this problem is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#82d204
 
V8.2 SAS/ACCESS to ODBC :
A Technical Support hot fix for this problem is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#82od02

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at:

A fix for Release 8.2 (TS2M0) for this issue is available at: