SUPPORT / SAMPLES & SAS NOTES
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | |||