Usage Note 35079: Error using TRIM() function when connected to SAS® Scalable Performance Data Server via ODBC
If you access SAS Scalable Performance Data Server via ODBC and you use the TRIM() function
in a WHERE clause, the following error message will appear in the SAS log file:
ERROR: CLI describe error: [SAS][SAS ODBC Driver][SAS Server] SPDS_NOTE:
Correct Syntax for select expression is:
Operating System and Release Information
| SPDS | Scalable Performance Data Server | Microsoft Windows 2000 Professional | 4.1 | 4.4 TSM8 | | 9.2 TS1M1 |
| Microsoft Windows XP Professional | 4.1 | 4.4 TSM8 | | 9.2 TS1M1 |
| 64-bit Enabled AIX | 4.1 | 4.4 TSM8 | | 9.2 TS1M1 |
| 64-bit Enabled HP-UX | 4.1 | 4.4 TSM8 | | 9.2 TS1M1 |
| 64-bit Enabled Solaris | 4.1 | 4.4 TSM8 | | 9.2 TS1M1 |
| HP-UX IPF | 4.1 | 4.4 TSM8 | | 9.2 TS1M1 |
| Solaris for x64 | 4.1 | 4.4 TSM8 | | 9.2 TS1M1 |
*
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.
| Date Modified: | 2009-07-28 18:51:23 |
| Date Created: | 2009-03-09 15:51:28 |
