SUPPORT / SAMPLES & SAS NOTES
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 | ||