SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 50395: "SPDS_ERROR: Parse Failure" when using table alias in SQL pass-through

DetailsHotfixAboutRate It

If you attempt to use table alias in SQL pass-through, an error message similar to the following might occur:

    SPDS_ERROR: Parse Failure: update spdslib.tablename #z SET ID = 176897;

    SPDS_ERROR: SQL passthru expression contained errors.
    ERROR: SPDS Sql Passthru Error.

Select the Hot Fix tab in this Note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SPDSScalable Performance Data ServerMicrosoft Windows Server 2003 Datacenter 64-bit Edition4.52 HF74.52 HF8
Microsoft Windows Server 2003 Enterprise 64-bit Edition4.52 HF74.52 HF8
Microsoft Windows XP 64-bit Edition4.52 HF74.52 HF8
Microsoft® Windows® for x644.52 HF74.52 HF8
Microsoft Windows Server 2003 Datacenter Edition4.52 HF74.52 HF8
Microsoft Windows Server 2003 Enterprise Edition4.52 HF74.52 HF8
Microsoft Windows Server 2003 Standard Edition4.52 HF74.52 HF8
Microsoft Windows Server 2003 for x644.52 HF74.52 HF8
64-bit Enabled AIX4.52 HF74.52 HF8
64-bit Enabled HP-UX4.52 HF74.52 HF8
64-bit Enabled Solaris4.52 HF74.52 HF8
HP-UX IPF4.52 HF74.52 HF8
Linux for x644.52 HF74.52 HF8
Solaris for x644.52 HF74.52 HF8
* 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.