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:

1. The temporary target table for the Join transformation is redirected to a database management system (DBMS) library.
2. The Advanced pane on the Options tab contains definitions for DBMS-specific options.
3. 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

* 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.

---

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#63434

---

A fix for this issue for SAS Middle Tier 9.4_M6 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/D8T.html#63434

---

A fix for this issue for Data Integration Studio 4.7_M6 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/D8Y.html#63434

---

A fix for this issue for Data Integration Studio 4.904 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/D8Y.html#63434

---

A fix for this issue for SAS Management Console 9.4_M5 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/B6T.html#63434

---

A fix for this issue for Data Integration Studio 4.903 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/C5F.html#63434

---

A fix for this issue for SAS Management Console 9.4_M4 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/A4L.html#63434

---

A fix for this issue for Data Integration Studio 4.902 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/A6K.html#63434

---

In SAS® Data Integration Studio, options that are specified in the "Advanced" pane on the "Options" tab in the Join Properties window are not retained. This issue occurs after the job is saved, closed, and reopened.

Type:	Problem Note
Priority:	high

Date Modified:	2019-11-08 09:34:41
Date Created:	2018-12-28 15:32:45