32083 - SUBSTRN function reference in query produces errors

Problem Note 32083: SUBSTRN function reference in query produces errors

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 Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed
SPDS	Scalable Performance Data Server	Microsoft® Windows® for x64	4.4 TSM0	4.4 TSM4
		Microsoft Windows XP 64-bit Edition	4.4 TSM0	4.4 TSM4
		Microsoft Windows Server 2003 Enterprise 64-bit Edition	4.4 TSM0	4.4 TSM4
		Microsoft Windows Server 2003 Datacenter 64-bit Edition	4.4 TSM0	4.4 TSM4
		Microsoft® Windows® for 64-Bit Itanium-based Systems	4.4 TSM0	4.4 TSM4
		HP-UX IPF	4.4 TSM0	4.4 TSM4
		Solaris for x64	4.4 TSM0	4.4 TSM4
		64-bit Enabled Solaris	4.4 TSM0	4.4 TSM4
		64-bit Enabled HP-UX	4.4 TSM0	4.4 TSM4
		64-bit Enabled AIX	4.4 TSM0	4.4 TSM4
		Windows Vista	4.4 TSM0	4.4 TSM4
		Windows Millennium Edition (Me)	4.4 TSM0	4.4 TSM4
		Microsoft Windows XP Professional	4.4 TSM0	4.4 TSM4
		Microsoft Windows Server 2003 Standard Edition	4.4 TSM0	4.4 TSM4
		Microsoft Windows Server 2003 Enterprise Edition	4.4 TSM0	4.4 TSM4
		Microsoft Windows Server 2003 Datacenter Edition	4.4 TSM0	4.4 TSM4
		Microsoft Windows NT Workstation	4.4 TSM0	4.4 TSM4
		Microsoft Windows 2000 Professional	4.4 TSM0	4.4 TSM4
		Microsoft Windows 2000 Server	4.4 TSM0	4.4 TSM4
		Microsoft Windows 2000 Datacenter Server	4.4 TSM0	4.4 TSM4
		Microsoft Windows 2000 Advanced Server	4.4 TSM0	4.4 TSM4
		Microsoft Windows 95/98	4.4 TSM0	4.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.

Type:	Problem Note
Priority:	medium

Date Modified:	2008-05-16 18:54:44
Date Created:	2008-05-13 10:11:19