Problem Note 35879: Data imported from a DB2 library may be corrupt
 |  |  |  |  |
A data set imported from a SAS® Access to DB2 library using SAS integration may be corrupt. Data on every hundredth row may be replaced with zeros or blanks. That is, data on rows 101, 201, 301, and so on, will be replaced with zeros if a numeric column, blanks if a character column.
This problem occurs when JMP® is interfaced with either SAS® 9.1.3 or SAS® 9.2.
The only work around is to specify all column names to be imported. This can be accomplished through the JMP user interface in the Browse SAS Data window by disclosing the Import Options, then select the Select Columns button. Select the columns to be imported in the Select Columns window, click OK, then click the Import button in the Browse SAS Data window.
A hot fix is available for this issue. Please select the hot fix tab of this note to access it.
The problem has been fixed in SAS® 9.2 TS2M2
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| JMP Software | JMP software | Microsoft Windows XP Professional | 8.0 | 8.0.2 | 9.2 TS2M0 | 9.2 TS2M2 |
| Windows Vista | 8.0 | 8.0.2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Linux for x64 | 8.0 | 8.0.2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows XP 64-bit Edition | 8.0 | 8.0.2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#035879A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#035879A fix for this issue for Base SAS 9.21_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A50.html#35879| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2009-05-11 13:06:26 |
| Date Created: | 2009-05-11 10:02:06 |
