Problem Note 63434: Advanced options for a Join transformation are not retained after a job is saved, closed, and reopened
 |  |  |  |  |
Options that are specified in the Advanced pane on the Options tab in the Job Properties window for a SQL Join transformation are not retained when the following conditions are true:
- The temporary target table for the Join transformation is redirected to a database management system (DBMS) library.
- The Advanced pane on the Options tab contains definitions for DBMS-specific options.
- The job is saved and then closed.
When the job is reopened, the DBMS-specific options are no longer defined.
The only workaround for this issue is to override the code generation for the Join transformation and to enter manually the missing options in the appropriate location within the code.
Click the Hot Fix tab in this note to access the hot fix for this issue.
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 10 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
| Microsoft Windows 8.1 Pro x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Windows 7 Professional x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Windows 7 Enterprise x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 Std | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 R2 Std | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 Datacenter | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2008 for x64 | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 R2 | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Enterprise x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Pro x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Enterprise x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
| Microsoft® Windows® for x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 | ||
A fix for this issue for SAS Management Console 9.4_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D8N.html#63434A fix for this issue for SAS Middle Tier 9.4_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D8T.html#63434A fix for this issue for Data Integration Studio 4.7_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D8Y.html#63434A fix for this issue for Data Integration Studio 4.904 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D8Y.html#63434A fix for this issue for SAS Management Console 9.4_M5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B6T.html#63434A fix for this issue for Data Integration Studio 4.903 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C5F.html#63434A fix for this issue for SAS Management Console 9.4_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A4L.html#63434A fix for this issue for Data Integration Studio 4.902 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A6K.html#63434| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-11-08 09:34:41 |
| Date Created: | 2018-12-28 15:32:45 |