Problem Note 5647: Using LOCATION= in PROC ACCESS can cause error or incorrect
table to be used
If you try to create an access and view descriptor on a remote DB2
table via DDF (Distributed Data Facility) by specifying LOCATION= for
the remote location and TABLE=AUTHORIZATION_ID.TABLENAME, the correct
three-level name is passed to DB2 and the view is created
successfully. However, subsequently accessing the view may cause a
variety of problems. If SSID= was not specified when the view was
created, you get the following message:
ERROR: Cannot connect to server , rc = 0.
If SSID= was specified when the view was created, SAS incorrectly
connects to, and attempts to locate a table on, that subsystem, rather
than on the remote location. This may cause the wrong table to be
retrieved or updated, if there is a table with that name on that
subsystem. If a table with that name does not exist on that
subsystem, you get an error that the table does not exist.
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#005647
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 TS M0 |
*
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: | alert |
| Topic: | SAS Reference ==> Procedures ==> ACCESS
|
| Date Modified: | 2002-04-22 16:09:12 |
| Date Created: | 2001-08-16 11:05:41 |
