Select Your Region
Americas
Europe
Middle East & Africa
Asia Pacific
![]() | ![]() | ![]() | ![]() | ![]() |
Prior to SAS SPD Server 4.4 TSM3, if you issued a SELECT statement containing a LIKE clause, the results returned were incorrect. Here is an example of code that would produce incorrect results: proc sql; select * from libname.table where x like 'abc\_xyz' escape '\'; quit; If you issued the same code through a query with explicit pass-through, you would receive a parsing error. Changes have been made in SPD Server 4.4 TSM3 so that the server can handle the SQL and return correct results, but SQL generated by SPD Server with a LIKE and ESCAPE clause will still fail with a parsing error.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SPDS | Scalable Performance Data Server | Tru64 UNIX | 4.4 | 4.4 | 3.0 TS M0 | |
Solaris for x64 | 4.4 | 4.4 | 3.0 TS M0 | |||
HP-UX IPF | 4.4 | 4.4 | 3.0 TS M0 | |||
64-bit Enabled Solaris | 4.4 | 4.4 | 3.0 TS M0 | |||
64-bit Enabled HP-UX | 4.4 | 4.4 | 3.0 TS M0 | |||
64-bit Enabled AIX | 4.4 | 4.4 | 3.0 TS M0 | |||
Windows | 4.4 | 4.4 | 3.0 TS M0 |