Problem Note 7858: Incorrect list of tables is displayed when a libref is pointing to a
remote location
If a libref that points to a remote location via the libname option
LOCATION= is used in a manner that requires the retrieval of information
about the list of tables (not columns), the list shown will be a list
of the local tables rather than the remote tables. This problem is
caused by the fact that when querying SYSIBM.SYSTABLES the location is
not used and so we query the local table SYSIBM.SYSTABLES, not the
one on the remote machine. This only occurs with the table names.
The column information is queried correctly.
This can cause problems when the user tries to then do something with
that table thinking it is remote and it is actually not there or has
trouble locating a table that they know is there. This can cause
errors to surface in the log.
There is not any current workaround.
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#007858
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 8 TS M0 | 9.1 TS1M0 |
*
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: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> DB2
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2003-11-26 08:11:34 |
| Date Created: | 2002-06-25 15:24:28 |
