Problem Note 10795: Wrong Sybase table accessed when using the SCHEMA LIBNAME option
Using the SCHEMA= LIBNAME option with SAS/ACCESS Interface to Sybase,
SAS will access the Sybase table in the USERID schema, not the schema
specified by the SCHEMA= option on the LIBNAME statement. As a
workaround, use the SCHEMA= dataset option.
A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#010795
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Sybase | Microsoft Windows 2000 Server | 8.2 TS2M0 | |
| Windows Millennium Edition (Me) | 8.2 TS2M0 | |
| Microsoft Windows 95/98 | 8.2 TS2M0 | |
| Microsoft Windows 2000 Advanced Server | 8.2 TS2M0 | |
| Microsoft Windows 2000 Datacenter Server | 8.2 TS2M0 | |
| Microsoft Windows NT Workstation | 8.2 TS2M0 | |
| Microsoft Windows 2000 Professional | 8.2 TS2M0 | |
| Microsoft Windows XP Professional | 8.2 TS2M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Sybase
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2004-09-16 13:56:22 |
| Date Created: | 2003-09-09 15:26:33 |
