INSTALLATION INSTRUCTIONS FOR HOT FIX 82OD09 ON AIX BEFORE DOWNLOADING: The hot fix 82OD09 addresses the issue(s) in Release 8.2 (TS2M0) of SAS/ACCESS Interface to ODBC Server software on AIX as documented in SAS Note(s): SN-006004 "ERROR: CLI open cursor error: [IBM][CLI Driver] CLI0125E Function sequence error" issued when using SAS/ACCESS Interface to DB2 SN-005708 ERROR: SQL0514N The cursor "SQLCURCS297" is not in prepared state SN-006276 New special queries added for ODBC and DB2: SQLDataSources and SQLDBMSInfo SN-005997 Access AS400 data using Access Interface to ODBC can cause ERROR:[merant][ODBC driver][DB2/400] Keyword FOR not expected. SN-005996 Access Interface to ODBC when accessing MSAccess data may cause data to be overwritten if using APPEND operations SN-005330 PROC APPEND to SQL Server using BCP option will insert data incorrectly SN-004053 CLI ODBC driver error occurs when using SAS/ACCESS Interface to ODBC to access LANDMARK DBMS, through LANDMARK ODBC driver SN-006323 Unable to get a single connection when using CONNECTION=GLOBALREAD as documentation would suggest SN-006293 Read Isolation Level defaults to CR when using SAS/Access Interface to DB2 SN-006312 CLI prepare error using NEON ODBC Driver to access DB2 on MVS with Access to ODBC on Windows SN-008603 "No data found" error occurs when trying to update or delete from a DB2 table with SQL SN-009478 SAS/Access to ODBC accessing Sql Server 2000 generates errors when creating a temporary table SN-009773 Incorrect data when KEEP= contains a field with a binary data type SN-009914 /UNIQUE option does not work with ODBC engine for character typed variables SN-012061 "ERROR: No matching observation was found in MASTER data set" is issued after applying HOTFIX 82D220 SN-013571 Bus Error accessing DBMS table via SAS/ACCESS to ODBC with rowset_size >1 SN-013504 SQL3061N received bulkloading to a DB2 table in a DBCS database SN-013980 DB2 bulk loader does not run with ALLOW READ ACCESS enabled which may be reviewed at: http://support.sas.com/techsup/unotes/SN/006/006004.html http://support.sas.com/techsup/unotes/SN/005/005708.html http://support.sas.com/techsup/unotes/SN/006/006276.html http://support.sas.com/techsup/unotes/SN/005/005997.html http://support.sas.com/techsup/unotes/SN/005/005996.html http://support.sas.com/techsup/unotes/SN/005/005330.html http://support.sas.com/techsup/unotes/SN/004/004053.html http://support.sas.com/techsup/unotes/SN/006/006323.html http://support.sas.com/techsup/unotes/SN/006/006293.html http://support.sas.com/techsup/unotes/SN/006/006312.html http://support.sas.com/techsup/unotes/SN/008/008603.html http://support.sas.com/techsup/unotes/SN/009/009478.html http://support.sas.com/techsup/unotes/SN/009/009773.html http://support.sas.com/techsup/unotes/SN/009/009914.html http://support.sas.com/techsup/unotes/SN/012/012061.html http://support.sas.com/techsup/unotes/SN/013/013571.html http://support.sas.com/techsup/unotes/SN/013/013504.html http://support.sas.com/techsup/unotes/SN/013/013980.html The hot fix package that is downloaded is in compressed tar format. The name of the tar file is 82od09ar.tar.Z, and it contains the following files: * sasdblpa.82od09 the replacement executable containing the hot fix * sasdblpa a link to sasdblpa.82od09 * sasodbcb.82od09 the replacement executable containing the hot fix * sasodbcb a link to sasodbcb.82od09 * sasioodb.82od09 the replacement executable containing the hot fix * sasioodb a link to sasioodb.82od09 * sasodbdb.82od09 the replacement executable containing the hot fix * sasodbdb a link to sasodbdb.82od09 * sasdblda.82od09 the replacement executable containing the hot fix * sasdblda a link to sasdblda.82od09 * sasodb.82od09 the replacement executable containing the hot fix * sasodb a link to sasodb.82od09 * sasdbu.82od09 the replacement executable containing the hot fix * sasdbu a link to sasdbu.82od09 * sasdbub.82od09 the replacement executable containing the hot fix * sasdbub a link to sasdbub.82od09 * sasdbudb.82od09 the replacement executable containing the hot fix * sasdbudb a link to sasdbudb.82od09 * sasiodbu.82od09 the replacement executable containing the hot fix * sasiodbu a link to sasiodbu.82od09 * dbidbu.msg.82od09 the replacement executable containing the hot fix * dbidbu.msg a link to dbidbu.msg.82od09 * 82od09ar.aud a hot fix identifier file that will allow Technical Support to determine which fixes have been applied to a system * 82od09ar.txt a copy of these installation instructions; this file is installed in !SASROOT/hotfix/doc IMPORTANT NOTE(S): 1. You must have Release 8.2 (TS2M0) installed on your system before applying this hot fix. AFTER DOWNLOADING: The following instructions describe the steps for installing the files listed above. In this example, !SASROOT, the directory where Release 8.2 (TS2M0) is installed, is: /usr/lib/sas8 STEP 1: Assuming the tar file is downloaded to the user's HOME directory, follow these procedures to install the package. $> cd /usr/lib/sas8 $> uncompress -c $HOME/82od09ar.tar | tar -xf - STEP 2: Once the tar command is complete, the following line must be added as the first line of the !SASROOT/sasv8.cfg file: -path !SASROOT/hotfix/sasexe Do not modify any existing -PATH options in the !SASROOT/sasv8.cfg file. STEP 3: Change the ownership (using the chown command) and permissions (using the chmod command) on the files in the !SASROOT/hotfix/sasexe directory to match the ownership and permissions on the files in the !SASROOT/sasexe directory. This completes the installation of hot fix 82OD09 on AIX.