Problem Note 67173: Errors occur in pass-through code when options for DBMS library definitions in metadata are incorrectly included or omitted from the CONNECT statement
 |  |  |  |  |
SQL procedure pass-through code that is generated by SAS® Data Integration Studio might fail with errors when the options that are specified for database management system (DBMS) library definitions in the metadata are incorrectly included or omitted from the CONNECT statement.
One workaround for this issue is as follows:
- Open the Code tab in the SAS Data Integration Studio transformation that is experiencing the issue.
- Change the Code generation mode selection from Automatic to User written body.
- Remove or add any DBMS option that is being incorrectly included or omitted, respectively.
Click the Hot Fix tab in this note to access the hot fix for this issue.
When the hot fix is applied, a new option, Use Connect Using Syntax, appears under Job Properties on the Options tab. Setting the Use Connect Using Syntax option to Yes will alter the code generation so that the CONNECT USING statement is generated instead of a CONNECT statement. The CONNECT USING statement automatically includes the appropriate options that are defined for the DBMS library in metadata.
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® for x64 | 4.7 | 9.4 TS1M0 | ||
| Microsoft Windows 8 Enterprise x64 | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows 8 Pro x64 | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Pro x64 | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows 10 | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 R2 | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 for x64 | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 Datacenter | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 R2 Std | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 Std | 4.7 | 9.4 TS1M0 | ||||
| Windows 7 Enterprise x64 | 4.7 | 9.4 TS1M0 | ||||
| Windows 7 Professional x64 | 4.7 | 9.4 TS1M0 | ||||
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#67173A fix for this issue for Data Integration Studio 4.904 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D8Y.html#67173A fix for this issue for SAS Middle Tier 9.4_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D8T.html#67173| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-02-01 08:59:01 |
| Date Created: | 2020-12-30 16:20:16 |