Problem Note 40005: An error occurs in the SAS® Data Integratio Studio job log due to invalid truncate syntax for a SAS® Scalable Performance Date Server® table
 |  |  |  |  |
SAS Data Integration Studio 4.21 generates a TRUNCATE TABLE SQL pass-through statement to truncate the rows in the target SAS SPDS table if this option is selected in the SAS SPDS Table Loader or standard Table Loader. This will produce the following error:
SPDS_ERROR: Parse Failure: #truncate table ...
SAS Data Integration Studio should instead generate SPDO proceedure syntax to truncate the target table.
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* | |||
| SAS System | SAS Data Integration Studio | Microsoft Windows Server 2003 Standard Edition | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
A fix for this issue for SAS Data Integration Studio 4.21_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B51.html#40005
This error displays: "SPDS_ERROR: Parse Failure: #truncate table ... "
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2010-06-23 13:44:41 |
| Date Created: | 2010-06-16 09:11:13 |