SUPPORT / SAMPLES & SAS NOTES
Problem Note 56173: WHERE constraints on SAS® Scalable Performance Data Server tables are removed when you use PROC SPDO with a TRUNCATE statement
 |  |  |  |  |
If you use the SPDO procedure with a TRUNCATE statement to truncate a SAS SPD Server table, WHERE constraints are removed.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SPDS | Scalable Performance Data Server | Microsoft® Windows® for x64 | 5.1 HF3 | 5.1 HF4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 5.1 HF3 | 5.1 HF4 | ||||
| Microsoft Windows Server 2008 for x64 | 5.1 HF3 | 5.1 HF4 | ||||
| Windows 7 Enterprise x64 | 5.1 HF3 | 5.1 HF4 | ||||
| 64-bit Enabled AIX | 5.1 HF3 | 5.1 HF4 | ||||
| 64-bit Enabled Solaris | 5.1 HF3 | 5.1 HF4 | ||||
| HP-UX IPF | 5.1 HF3 | 5.1 HF4 | ||||
| Linux for x64 | 5.1 HF3 | 5.1 HF4 | ||||
| Solaris for x64 | 5.1 HF3 | 5.1 HF4 | ||||