SUPPORT / SAMPLES & SAS NOTES
Problem Note 32154: SQL Join generates invalid code when formats or functions used within expressions match column names in source or target tables
 |  |  |  |  |
When the format or function name exactly matches a column name in either a source or target table, SQL Join code generation incorrectly prepends a table name in front of any format or function name reference. The result is invalid code that fails with errors when it is executed.
The only way to circumvent this issue is to change the source or target table column names so that they no longer match the format or function names that are being used within the transformation.
Select 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 2000 Advanced Server | 3.3 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows 2000 Datacenter Server | 3.3 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Server | 3.3 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Professional | 3.3 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 3.3 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 3.3 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.3 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 3.3 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||