49995 - Code for the macro variable OPTEmitSQL is incorrect when the prompt type Data Source Column is used with the option "Emit SQL Syntax for column"

Problem Note 49995: Code for the macro variable OPTEmitSQL is incorrect when the prompt type Data Source Column is used with the option "Emit SQL Syntax for column"

A Generated transformation for which a prompt is defined results in incorrect code under the following conditions:

The code that is generated for the macro variable OPTEmitSQL only refers to one table, as shown in the following example:

%let OPTEmitSQL = TABLE1.Table1_Col, TABLE1.Table2_Col, TABLE1.Table-n_Col;

The code should read as follows:

%let OPTEmitSQL = TABLE1.Table1_Col, TABLE2.Table2_Col, TABLE-n.Table-n_Col;

Click the Hot Fix tab in this note to access the hot fix for this issue.

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SAS System	SAS Data Integration Studio	Microsoft® Windows® for x64	4.2	4.7	9.2 TS2M0	9.4 TS1M0
		Microsoft Windows Server 2003 Datacenter Edition	4.2		9.2 TS2M0
		Microsoft Windows Server 2003 Enterprise Edition	4.2		9.2 TS2M0
		Microsoft Windows Server 2003 Standard Edition	4.2		9.2 TS2M0
		Microsoft Windows Server 2003 for x64	4.2		9.2 TS2M0
		Microsoft Windows Server 2008 for x64	4.2	4.7	9.2 TS2M0	9.4 TS1M0
		Microsoft Windows XP Professional	4.2		9.2 TS2M0
		Windows Vista	4.2		9.2 TS2M0
		Windows Vista for x64	4.2		9.2 TS2M0

* 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 Data Integration Studio 4.6 is available at:

A fix for this issue for SAS Data Integration Studio Server Data 4.6 is available at:

Type:	Problem Note
Priority:	medium

Date Modified:	2013-05-29 09:07:28
Date Created:	2013-05-21 08:34:55