Problem Note 68840: Database connection information for a source table is used when creating a new database table with the Create Table transformation
 |  |  |  |  |
The Create Table transformation for SQL procedure pass-through code uses the connection information that is provided in the source table library metadata in order to create a new table. However, this action might create a table in the incorrect schema. It can also cause errors if you do not have the proper permissions to create a table in the schema defined to the source library. Other errors are possible.
A workaround for the issue is to change the selection for the Code generation mode field to User written body. Then manually correct the connection information in the CONNECT statement for the PROC SQL pass-through code.
Click the Hot Fix tab in this note to access the hot fix for this issue.
This hot fix, for the SAS® 9.4M7 (TS1M7) release, provides a new option, Use the target table library for the connect statement. Set the option value to Yes to indicate that the target library metadata should be used when creating a new database table.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Integration Studio | Microsoft Windows Server 2012 Datacenter | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 |
| Microsoft Windows Server 2008 for x64 | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2008 R2 | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2008 | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 10 | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Pro x64 | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Pro 32-bit | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Enterprise x64 | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Pro x64 | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Pro 32-bit | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Enterprise x64 | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Enterprise 32-bit | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft® Windows® for x64 | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 R2 Std | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 Std | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2016 | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Enterprise 32 bit | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Enterprise x64 | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Home Premium 32 bit | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Home Premium x64 | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Professional 32 bit | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Professional x64 | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Ultimate 32 bit | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Ultimate x64 | 4.903 | 4.906 | 9.4 TS1M5 | 9.4 TS1M8 | ||
A fix for this issue for Data Integration Studio 4.7_M7 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J7S.html#68840| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2023-02-23 13:31:49 |
| Date Created: | 2022-01-27 10:29:00 |