While working a project, a SQL syntax error with NA.NA.ColumnName occurs. The problem occurs because three SQL queries that are used by the middle tier have the incorrect syntax NA.NA.ColumnName. The correct syntax is NA.ColumnName.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Warranty Analysis | Microsoft Windows Server 2003 Enterprise Edition | 4.1 | 4.3 | 9.1 TS1M3 SP4 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Datacenter Edition | 4.1 | 4.3 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
Microsoft Windows Server 2003 Standard Edition | 4.1 | 4.3 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
64-bit Enabled AIX | 4.1 | 4.3 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
64-bit Enabled Solaris | 4.1 | 4.3 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
HP-UX IPF | 4.1 | 4.3 | 9.1 TS1M3 SP4 | 9.2 TS2M3 |