INSTALLATION INSTRUCTIONS FOR HOT FIX 82SB12 ON SOLARIS BEFORE DOWNLOADING: The hot fix 82SB12 addresses the issue(s) in Release 8.2 (TS2M0) of SAS/ACCESS Interface to SYBASE software on Solaris as documented in SAS Note(s): SN-004321 Unable to execute multiple SELECT statements with Access to Sybase in Version 7 and Version 8 of the SAS System SN-005897 BULKLOAD of DOLLAR 12.2 format using SAS/ACCESS Interface to SYBASE produces an OVERFLOW error SN-005909 Unable to append to a SYBASE table with BULKCOPY if an identity column exists on the table SN-006327 SQL Pass-Through to Sybase EXECUTE statement allows only one statement SN-006335 Using PROC DBLOAD APPEND with BULKCOPY may cause data corruption SN-008034 Segmentation Violation in SAS/ACCESS Interface to Sybase when loading a table with BULKCOPY on Solaris SN-008355 PROC DBLOAD password is not X'd-out in the SAS log when using SAS/ACCESS Interface to Sybase SN-008473 "Error in results set for update" when updating a Sybase view with DATA step MODIFY SN-008967 SAS/ACCESS Interface to Sybase incorrectly reads the Sybase value 'JUN 21 2001 2:03:46:793AM' and generates a warning message SN-010317 Access to Sybase V8.2 is not honoring the database= option for updates SN-010867 Unable to update a Sybase table with an Identity field with SAS V8.2 SN-012997 Notes, warning or errors are not being issued when attempting to insert into a Sybase table with triggers using RAISERROR with PROC APPEND SN-001373 SAS/ACCESS Version 6 incompatibility issues with SAS Version 7 and Version 8 SN-010795 Wrong Sybase table accessed when using the SCHEMA LIBNAME option SN-015017 Segmentation Violation error issued intermittently when accessing a Sybase server that is not available which may be reviewed at: http://support.sas.com/techsup/unotes/SN/004/004321.html http://support.sas.com/techsup/unotes/SN/005/005897.html http://support.sas.com/techsup/unotes/SN/005/005909.html http://support.sas.com/techsup/unotes/SN/006/006327.html http://support.sas.com/techsup/unotes/SN/006/006335.html http://support.sas.com/techsup/unotes/SN/008/008034.html http://support.sas.com/techsup/unotes/SN/008/008355.html http://support.sas.com/techsup/unotes/SN/008/008473.html http://support.sas.com/techsup/unotes/SN/008/008967.html http://support.sas.com/techsup/unotes/SN/010/010317.html http://support.sas.com/techsup/unotes/SN/010/010867.html http://support.sas.com/techsup/unotes/SN/012/012997.html http://support.sas.com/techsup/unotes/SN/001/001373.html http://support.sas.com/techsup/unotes/SN/010/010795.html http://support.sas.com/techsup/unotes/SN/015/015017.html The hot fix package that is downloaded is in compressed tar format. The name of the tar file is 82sb12s2.tar.Z, and it contains the following files: * sasdblpe.82sb12 the replacement executable containing the hot fix * sasdblpe a link to sasdblpe.82sb12 * sasdblde.82sb12 the replacement executable containing the hot fix * sasdblde a link to sasdblde.82sb12 * sasiosyb.82sb12 the replacement executable containing the hot fix * sasiosyb a link to sasiosyb.82sb12 * syslx111.82sb12 the replacement executable containing the hot fix * syslx111 a link to syslx111.82sb12 * syslx125.82sb12 the replacement executable containing the hot fix * syslx125 a link to syslx125.82sb12 * sassybdb.82sb12 the replacement executable containing the hot fix * sassybdb a link to sassybdb.82sb12 * dbisyb.msg.82sb12 the replacement message file containing the hot fix * dbisyb.msg a link to dbisyb.msg.82sb12 * sassybac.82sb12 the replacement executable containing the hot fix * sassybac a link to sassybac.82sb12 * 82sb12s2.aud a hot fix identifier file that will allow Technical Support to determine which fixes have been applied to a system * 82sb12s2.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/82sb12s2.tar | tar -xf - STEP 2: Once the tar command is complete, it is necessary to edit the config files, !SASROOT/dbcs/sasv8.cfg and !SASROOT/sasv8.cfg. 1. The following lines must be added as the first lines of the !SASROOT/dbcs/sasv8.cfg file: -path !SASROOT/hotfix/sasexe -path !SASROOT/../hotfix/sasexe Also, the following line must be added as the first line of the !SASROOT/sasv8.cfg: -path !SASROOT/hotfix/sasexe Do not modify any existing -PATH options in the !SASROOT/dbcs/sasv8.cfg or !SASROOT/sasv8.cfg files. 2. Locate the -msg option in the config file !SASROOT/dbcs/sasv8.cfg. After the existing -msg option add add the following line: -insert msg !SASROOT/../hotfix/sasmsg The updated -MSG options should appear as follows: -msg !SASROOT/../sasmsg -insert msg !SASROOT/../hotfix/sasmsg Also, locate the -msg option in the config file !SASROOT/sasv8.cfg. After the existing -msg option add add the following line: -insert msg !SASROOT/hotfix/sasmsg The updated -MSG options should appear as follows: -msg !SASROOT/sasmsg -insert msg !SASROOT/hotfix/sasmsg Please be extremely careful not to modify the path in the default -MSG configuration option. STEP 3: A link to the correct version of sassyb must be created. Assuming !SASROOT is /usr/lib/sas8, execute the following commands: for Open Client 11.1.0 and Open Client 11.1.1: > cd /usr/lib/sas8/hotfix/sasexe > mv sassyb sassyb.bak > ln -s syslx111 sassyb for Open Client 12.5: > cd /usr/lib/sas8/hotfix/sasexe > mv sassyb sassyb.bak > ln -s syslx125 sassyb STEP 4: Change the ownership (using the chown command) and permissions (using the chmod command) on the files in the !SASROOT/dbcs/hotfix/sasexe directory to match the ownership and permissions on the files in the !SASROOT/dbcs/sasexe directory. Also, change the ownership and permissions 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 82SB12 on Solaris.