support.sas.com
 
 
support.sas.com


SAS/ACCESS Interface to DB2 9.21_M2

Hot Fix Downloads

* Important changes to Hot Fixes!

B94001 was replaced by B94020

B94003 was replaced by B94020

B94004 was replaced by B94020

B94005 was replaced by B94010

B94006 was replaced by B94020

B94007 was replaced by B94010

B94008 was replaced by B94010

B94009 was replaced by B94020

B94010
SAS/ACCESS Interface to DB2 9.21_M2
Issue(s) Addressed:Introduced:
41346 An error might be produced when you access a DB2 table that contains TIMESTAMP data types B94005
41347 An error occurs when you try to create metadata for DB2 columns with the TIMESTAMP data type B94005
42119 An error is issued when you attempt to register a DB2 table in metadata B94005
41678 Zero length character columns in DB2 are assigned a length of 32767 when read into SAS with the SAS/ACCESS® Interface to DB2 9.2 software B94007
33451 An error occurs when you run a DB2 stored procedure that has a question mark for a parameter value in SAS/ACCESS® Interface to DB2 B94008
42944 Incorrect lengths are assigned for DB2 GRAPHIC and VARGRAPHIC character data types in SAS/ACCESS® 9.2 Interface to DB2 (TS2M3) B94008
43769 The SAS® System increases a DB2 timestamp by 24 hours when the timestamp reaches a value of 23:59:59.999999 B94010
NOTE: If you install this hot fix, you must also install hot fix B25128 for Base SAS.
Windows Released: August 16, 2011     Documentation: B94010wn.html       Download: B94010wn.exe  
Windows for IPF Released: August 16, 2011     Documentation: B94010w6.html       Download: B94010w6.exe  
Windows for x64 Released: August 16, 2011     Documentation: B94010x6.html       Download: B94010x6.exe  
64-bit Enabled HP-UX Released: August 16, 2011     Documentation: B94010h6.html       Download: B94010h6.bin  
64-bit Enabled Solaris Released: August 16, 2011     Documentation: B94010s6.html       Download: B94010s6.bin  
64-bit Enabled AIX Released: August 16, 2011     Documentation: B94010r6.html       Download: B94010r6.bin  
Linux Released: August 16, 2011     Documentation: B94010lx.html       Download: B94010lx.bin  
HP-UX IPF Released: August 16, 2011     Documentation: B94010hx.html       Download: B94010hx.bin  
Linux for x64 Released: August 16, 2011     Documentation: B94010la.html       Download: B94010la.bin  
Solaris for x64 Released: August 16, 2011     Documentation: B94010sx.html       Download: B94010sx.bin  
Top ^

B94011 was replaced by B94020

B94012 was replaced by B94020

B94014 was replaced by B94020

B94015 was replaced by B94020

B94016 was replaced by B94020

B94020
SAS/ACCESS Interface to DB2 9.21_M2
Issue(s) Addressed:Introduced:
40104 Performance issues might occur when you access DB2 with SAS/ACCESS® 9.2 Interface to DB2 in the IBM z/OS operating environment B94001
40226 ALERT - Incorrect results might occur when you specify the READBUFF= option with SAS/ACCESS® Interface to DB2 in the IBM z/OS operating environment B94001
40717 ALERT - Errors might occur when you use the ACCESS procedure with SAS/ACCESS® Interface to DB2 and you are running SAS® 9.2(TS2M3) in the IBM z/OS environment B94001
41741 Performance degradation related to change in SQLDA definition B94003
41745 Accessing DB2 can result in System abend 0C4 in module SASIODB2 B94003
42115 ALERT - Retrieving long character variables from DB2 in the z/OS operating environment can return incorrect results B94004
42133 ALERT - Using Bulkload to insert into an already existing data set can result in incorrect data B94006
42697 ALERT - Incorrect results might occur when you specify the READBUFF= option with SAS/ACCESS® Interface to DB2 in the IBM z/OS operating environment B94009
42979 Using the DBKEY= option in the SQL procedure might cause incorrect results B94011
43510 An 0C1 or an 0C4 abend might occur when you use the READBUFF= option and explicit pass-through processing to access DB2 in the z/OS environment B94011
42266 Including an SQL statement within a PROC DBLOAD can result in the wrong table being created or updated B94012
45167 ALERT - Using the READBUFF= option might result in a data integrity issue B94014
45183 Using an SQL view while using a WHERE= data set option that results in a DB2 error might cause the step to continue executing B94015
45375 Using the DBSASTYPE data set option on a z/OS system might result in an error B94016
46215 A READBUFF option set to >1 might lead to errors when you access SAS/ACCESS® Interface to DB2 in the z/OS operating environment B94017
46856 ALERT - Using a value greater than 1 for the READBUFF option might result in wrong data when you access DB2 data on a z/OS system B94017
47285 ALERT - Null values might be appended to the end of VARCHAR variables when data is retrieved from DB2 in the z/OS operating environment B94018
48272 ALERT - An arithmetic exception in an explicit pass-through query to DB2 on a z/OS system might result in incorrect results B94020
NOTE: This hot fix requires that a DB2 bind be done with new DBRM members. Even if you have done a bind for SAS 9.2 TS2M3, the bind will need to be redone with these new members. See Usage Note 39564 for more details.
NOTE: If you install this hot fix, you must also install hot fix B25219 for Base SAS 9.21_M3.
z/OS Released: June 25, 2013     Documentation: B94020os.html D       Download: B94020os.bin  
D indicates that the Documentation has special pre-installation, post-installation or other unique instructions not commonly used for hot fix deployment.
Top ^




PLEASE CAREFULLY READ THE TERMS AND CONDITIONS OF THIS LICENSE AGREEMENT ("AGREEMENT") BEFORE DOWNLOADING MATERIALS FROM THIS SITE. BY DOWNLOADING ANY MATERIALS FROM THIS SITE, YOU ARE AGREEING TO THESE TERMS.
You are downloading software code ("Code") which will become part of a product ("Software") you currently have licensed from SAS Institute Inc. or one of its subsidiaries ("the Institute"). This Code is designed to either correct an error in the Software or to add functionality to the Software. The code is governed by the same agreement which governs the Software. If you do not have an existing agreement with the Institute governing the Software, you may not download the Code.
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand and product names are registered trademarks or trademarks of their respective companies.

Copyright © 2014 SAS Institute Inc. All Rights Reserved.