Problem Note 42266: Including an SQL statement within a PROC DBLOAD can result in the wrong table being created or updated
 |  |  |  |  |
Using SAS/ACCESS® Interface to DB2 on z/OS with SAS 9.2 TS2M3, can result in the wrong table being created or loaded into. This occurs when an SQL statement is included within the PROC DBLOAD step and the table being created or updated includes the authorization ID and that authorization ID differs from the default authorization ID. The one specified in the code is ignored and the default ID is used instead.
For example, running the following with ID SASDEMO1 results in the table SASDEMO1.CLASS being created instead of the requested SASDEMO2.CLASS.
Removing the SQL statement results in the correct table, SASDEMO2.CLASS, to be created and loaded.
The only workaround is to split out the task being done in the SQL statement to another step.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.2 TS2M3 | 9.4 TS1M0 |
A fix for this issue for SAS/ACCESS Interface to DB2 9.21_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B94.html#42266| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2013-06-06 16:29:03 |
| Date Created: | 2011-02-02 13:25:11 |