Problem Note 46221: Referencing a DB2 alias on a z/OS system might result in an error
Running a query that includes a DB2 alias that references a remote DB2 table might result in the following error:
DSN00512E STATEMENT REFERENCE TO REMOTE OBJECT IS INVALID
A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS:
ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 0
SQLCODE: -512 SQLSTATE: 56023 SQLERRP: DSNXODIS
To fix this issue, apply the latest
SAS/ACCESS® Interface to DB2 hot fix and redo the DB2 bind using the DBRM members for SAS
® 9.2 TS2M3 with hot fixes.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.2 TS2M3 | 9.3 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 |
| Date Modified: | 2013-03-11 15:55:39 |
| Date Created: | 2012-04-04 12:08:57 |
