• Print |
• E-mail  |
• Bookmark

When joining two or more SAS/ACCESS view descriptors or DBMS tables
using different LIBNAME statements with CONNECTION=GLOBALSHARED
specified, the connection to the DBMS is shared.  This causes problems
if there is a SAS function included in the query and you are accessing
DB2/MVS, OLE/DB, or ODBC.  These SAS/ACCESS products allocate their
dictionaries at connection time rather than at load time.  The
dictionary is used to determine which SAS functions the engine has
DBMS replacements for.  Since the dictionary is not set appropriately,
an incorrect query may be passed to the DBMS, resulting in an error.

To circumvent the problem, change the query such that the connection
is not shared.


A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:

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

For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#005276

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) with Asian Language Support (DBCS) for this issue is available at: