Problem Note 9773: Incorrect data when KEEP= contains a field with a binary data type
You may receive incorrect data when using a KEEP= data set option or
statement containing a DB2 field with a binary data type. The problem
usually occurs when:
1) Fewer fields are listed in the KEEP= option or statement than
are contained in the DB2 table.
2) The length of the DB2 binary field is a multiple of 8.
Some or all of the fields listed after the binary field in the SAS data
buffer will contain incorrect data when these two conditions are met.
A workaround for this problem is to specify the DBMAX_TEXT option,
setting it to a value that is not a multiple of 8. The default value
for this option is 1024, a multiple of 8.
A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#009773
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to DB2 | Microsoft Windows XP Professional | 8.2 TS2M0 | 8.2 TS2M0 |
| Microsoft Windows 95/98 | 8.2 TS2M0 | 8.2 TS2M0 |
| Microsoft Windows NT Workstation | 8.2 TS2M0 | 8.2 TS2M0 |
| Solaris | 8.2 TS2M0 | 8.2 TS2M0 |
| Windows Millennium Edition (Me) | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled HP-UX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled Solaris | 8.2 TS2M0 | 8.2 TS2M0 |
| HP-UX | 8.2 TS2M0 | 8.2 TS2M0 |
| Tru64 UNIX | 8.2 TS2M0 | 8.2 TS2M0 |
| AIX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled AIX | 8.2 TS2M0 | 8.2 TS2M0 |
*
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.
| Type: | Problem Note |
| Priority: | high |
| Topic: | SAS Reference ==> LIBNAME Engines
Data Management ==> Data Sources ==> External Databases ==> DB2
|
| Date Modified: | 2003-06-03 11:58:42 |
| Date Created: | 2003-04-08 16:27:33 |
