Problem Note 46389: The incorrect DB2 table might be referenced when CURRENT SQLID is set within implicit pass-through
The LIBNAME option DBCONINIT= is used to pass a specific DBMS statement to be executed immediately after each DBMS connection is successfully established. If you use this option to submit the SET CURRENT SQLID= statement, the incorrect table can be referenced when that libref is used in subsequent code. The engine appropriately passes the statement to DB2. In subsequent code, however, rather than using that SQLID value, the engine uses either the value for the AUTHID=, SCHEMA=, or USER= option or the TSO ID under which the process is running. This occurs if none of those options were specified in the LIBNAME statement.
The only workaround is to use either the AUTHID= or the SCHEMA= option in the LIBNAME statement.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.2 TS1M0 | 9.4 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: | alert |
| Date Modified: | 2012-04-27 09:30:20 |
| Date Created: | 2012-04-23 12:12:54 |
