Problem Note 18957: The Loader transformation's "Update/Insert" technique in SAS® Data Integration Studio 3.4 might load nonmapped target-table columns with incorrect data
 |  |  |  |  |
The Loader transformation in SAS Data Integration Studio 3.4 provides a way to generate DATA-step code that updates a target table or inserts rows in the table, based on the match of an indexed field that is found by using the KEY= option in the MODIFY statement. It is possible that any missing or unmapped columns in the target table will be updated with values from the previously read row if the:
- load style is "Update/Insert"
- matching-rows technique is "Modify Using Index"
- "Blanks may replace non-blank values" check box is unchecked
Select 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 XP Professional | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
| Microsoft Windows 2000 Server | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Professional | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 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#18957A fix for this issue for SAS Data Integration Studio Server Data 9.2_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C63.html#18957A fix for this issue for SAS Data Integration Studio 3.4 is available at:
http://www.sas.com/techsup/download/hotfix/dis34.html#018957| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2012-02-10 10:25:48 |
| Date Created: | 2006-11-13 08:43:49 |