Problem Note 43256: SAS® Data Integration Studio uses the wrong SQL procedure statement when you clear the contents of a Netezza table
When you clear the contents of a Netezza table, an incorrect PROC SQL statement is used to remove all of the rows from the target table. This problem occurs when the following conditions are all true within a SAS Data Integration Studio job definition:
- Your target table resides in a Netezza library.
-
You set transformation options to enable explicit SQL pass-through processing.
-
You set transformation options so that the target table is truncated instead of replaced.
In this situation, the PROC SQL DELETE statement is used instead of the PROC SQL TRUNCATE statement.
The DELETE statement marks all of the rows to be deleted, but those rows are not removed immediately.
The TRUNCATE statement removes all of the rows from the target table, and it frees all of the disk space that is allocated to the table. As a result, the space is available for use immediately, and the rows are removed.
You can work around this issue by modifying the job definition so that one or more of the conditions listed earlier are no longer true.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Data Integration Studio | Microsoft Windows 2000 Advanced Server | 4.21 | | | |
| Microsoft Windows 95/98 | 4.21 | | | |
| Microsoft® Windows® for x64 | 4.21 | 4.3 | | 9.3 TS1M0 |
| Microsoft Windows 2000 Datacenter Server | 4.21 | | | |
| Microsoft Windows 2000 Server | 4.21 | | | |
| Microsoft Windows 2000 Professional | 4.21 | | | |
| Microsoft Windows NT Workstation | 4.21 | | | |
| Microsoft Windows Server 2003 Datacenter Edition | 4.21 | 4.3 | | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.21 | 4.3 | | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 4.21 | 4.3 | | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 4.21 | 4.3 | | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 4.21 | 4.3 | | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 4.21 | 4.3 | | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 4.21 | 4.3 | | 9.3 TS1M0 |
| Windows 7 Enterprise 32 bit | 4.21 | 4.3 | | 9.3 TS1M0 |
| Windows 7 Enterprise x64 | 4.21 | 4.3 | | 9.3 TS1M0 |
| Windows 7 Home Premium 32 bit | 4.21 | 4.3 | | 9.3 TS1M0 |
| Windows 7 Home Premium x64 | 4.21 | 4.3 | | 9.3 TS1M0 |
| Windows 7 Professional 32 bit | 4.21 | 4.3 | | 9.3 TS1M0 |
| Windows 7 Professional x64 | 4.21 | 4.3 | | 9.3 TS1M0 |
| Windows 7 Ultimate 32 bit | 4.21 | 4.3 | | 9.3 TS1M0 |
| Windows 7 Ultimate x64 | 4.21 | 4.3 | | 9.3 TS1M0 |
| Windows Millennium Edition (Me) | 4.21 | | | |
| Windows Vista | 4.21 | 4.3 | | 9.3 TS1M0 |
| Windows Vista for x64 | 4.21 | 4.3 | | 9.3 TS1M0 |
*
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.
The SQL procedure's DELETE statement is used instead of the PROC SQL TRUNCATE statement when you clear Netezza tables.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2011-05-24 13:37:20 |
| Date Created: | 2011-05-13 08:21:08 |
