Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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: