SUPPORT

Select Your Region

Visit the Cary, NC, US corporate headquarters site

Americas

Europe

Middle East & Africa

Asia Pacific

View our worldwide contacts list for help finding your region

Americas

Europe

Middle East & Africa

Asia Pacific

Sign In

Get access to My SAS, trials, communities and more.

Sign Out

Get access to My SAS, trials, communities and more.

SAS Sites

sas.com
Support
Blogs
Communities
Developer
Curiosity
Videos

Documentation

Learn
Brand
PartnerNet
Merchandise
SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 32083: SUBSTRN function reference in query produces errors

DetailsHotfixAboutRate It

Referencing the SUBSTRN function in an SQL query to SPD Server may produce the following errors: 

   SPDS_ERROR: Function SUBSTRN could not be located.
   SPDS_ERROR: SQL passthru expression contained errors.
   ERROR: SPDS Sql Passthru Error.

Support for the SUBSTRN function is available beginning with SPD Server 4.4 TSM4.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SPDSScalable Performance Data ServerMicrosoft® Windows® for x644.4 TSM04.4 TSM4
Microsoft Windows XP 64-bit Edition4.4 TSM04.4 TSM4
Microsoft Windows Server 2003 Enterprise 64-bit Edition4.4 TSM04.4 TSM4
Microsoft Windows Server 2003 Datacenter 64-bit Edition4.4 TSM04.4 TSM4
Microsoft® Windows® for 64-Bit Itanium-based Systems4.4 TSM04.4 TSM4
HP-UX IPF4.4 TSM04.4 TSM4
Solaris for x644.4 TSM04.4 TSM4
64-bit Enabled Solaris4.4 TSM04.4 TSM4
64-bit Enabled HP-UX4.4 TSM04.4 TSM4
64-bit Enabled AIX4.4 TSM04.4 TSM4
Windows Vista4.4 TSM04.4 TSM4
Windows Millennium Edition (Me)4.4 TSM04.4 TSM4
Microsoft Windows XP Professional4.4 TSM04.4 TSM4
Microsoft Windows Server 2003 Standard Edition4.4 TSM04.4 TSM4
Microsoft Windows Server 2003 Enterprise Edition4.4 TSM04.4 TSM4
Microsoft Windows Server 2003 Datacenter Edition4.4 TSM04.4 TSM4
Microsoft Windows NT Workstation4.4 TSM04.4 TSM4
Microsoft Windows 2000 Professional4.4 TSM04.4 TSM4
Microsoft Windows 2000 Server4.4 TSM04.4 TSM4
Microsoft Windows 2000 Datacenter Server4.4 TSM04.4 TSM4
Microsoft Windows 2000 Advanced Server4.4 TSM04.4 TSM4
Microsoft Windows 95/984.4 TSM04.4 TSM4
* 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.