SQL
Last Updated: 16JUN98
=====================

File:               - Desciption:
--------------------------------------------------------------------------------
                    -
README              - Listing of files in this directory
sassqxo             - Executable for PROC SQL fix for files greater than  2 gb.
                      PLEASE NOTE:  Module can be installed for  Release 6.12
                      TS020 and Release 6.12 TS045.  If you  install maintenance
                      Release 6.12 TS050 or higher after the SQL fix is
                      installed, you must reinstall this executable.
sassqxs             - Executable for PROC SQL fix for files greater than  2 gb.
                      PLEASE NOTE:  Module can be installed for  Release 6.12
                      TS020 and Release 6.12 TS045.  If you  install maintenance
                      Release 6.12 TS050 or higher after the SQL fix is
                      installed, you must reinstall this executable.
sassqxu             - Executable for PROC SQL fix for files greater than  2 gb.
                      PLEASE NOTE:  Module can be installed for  Release 6.12
                      TS020 and Release 6.12 TS045.  If you  install maintenance
                      Release 6.12 TS050 or higher after the SQL fix is
                      installed, you must reinstall this executable.

INSTRUCTIONS FOR APPLYING THE PROC SQL 2 GIG FIX:

1) Save the old files:
unix_prompt> cd !SASROOT/sasexe/base
unix_prompt> cp sassqxo sassqxo.orig
unix_prompt> cp sassqxs sassqxs.orig
unix_prompt> cp sassqxu sassqxu.orig

2) Download the new files that fixes the PROC SQL 2 GIG bug.  
    unix_prompt> ftp ftp.sas.com
                 userid: anonymous
                 password: <email address>
    ftp> binary
    ftp> cd /techsup/download/base/sql/{OS}  /*OS is sun, aixr, or hp*/
    ftp> get README README
    ftp> get sassqxo !SASROOT/sassqxo.sql2gig
    ftp> get sassqxs !SASROOT/sassqxs.sql2gig
    ftp> get sassqxu !SASROOT/sassqxu.sql2gig
    ftp> quit
    unix_prompt> cp sassqxo.sql2gig !SASROOT/sasexe/base/sassqxo
    unix_prompt> cp sassqxs.sql2gig !SASROOT/sasexe/base/sassqxs
    unix_prompt> cp sassqxu.sql2gig !SASROOT/sasexe/base/sassqxu

NOTE:  Be sure the download was successful! Verify the file sizes and
permissions of the modules as follows:

For SUN/SOLARIS:
-rwxr-xr-x  65536  sassqxo
-rwxr-xr-x  57344  sassqxs      
-rwxr-xr-x  81920  sassqxu

FOR AIX/RS6000:
-rwxr-xr-x   69642 sassqxo
-rwxr-xr-x   86601 sassqxs    
-rwxr-xr-x   27884 sassqxu

FOR HPUX:
-r-xr-xr-x   69632 sassqxo
-r-xr-xr-x   61440 sassqxs
-r-xr-xr-x   90112 sassqxu

3) Be sure you understand that if you install a MAINTENANCE Release TS050 
or higher, then you will need to recopy the executables again. If you used 
the exact naming comventions used above, then all you need to do is apply 
the MAINTENANCE RELEASE and then do the copy again, like this:

unix_prompt> cp sassqxo.sql2gig !SASROOT/sasexe/base/sassqxo
unix_prompt> cp sassqxs.sql2gig !SASROOT/sasexe/base/sassqxs
unix_prompt> cp sassqxu.sql2gig !SASROOT/sasexe/base/sassqxu