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

File:               - Desciption:
--------------------------------------------------------------------------------
                    -
README              - Listing of files in this directory
README.S2G          - Installation instructions for the PROC SQL 2 GIG fix.
sassqxo             - Executable for PROC SQL fix for files greater than  2 gb.
                      PLEASE NOTE:  Module can be installed for  Release 6.12
                      TS040 or higher.  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
                      TS040 or higher.  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
                      TS040 or higher.  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> copy sassqxo sassqxo.orig
      unix_prompt> copy sassqxs sassqxs.orig
      unix_prompt> copy sassqxu sassqxu.orig

2)  Download the new files that fix the PROC SQL 2 GIG problem.
      unix_prompt> ftp ftp.sas.com
                    userid:  anonymous
                    password:  <your email address>

      ftp> binary  
      ftp> get README.S2G README.S2G
      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 that the file 
sizes of the modules are as follows:

FOR AOSF: 

   sassqxo     --  98304 bytes or 96 kb
   sassqxs     --  90112 bytes or 88 kb
   sassqxu     --  155648 bytes or 152 kb

3)  If you have licensed and installed Enterprise Miner and have
applied the maintenance release TS050 (needed only by sites 
with Enterprise Miner), then you will need to recopy the 
executables again. If you used the exact installation sequence 
listed above, then all you need to do is apply the MAINTENANCE
RELEASE and do the copy again.  For example: 

      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
 
If you fail to recopy the executables after installing the 
maintenance, the results are unpredictable. You can receive fatal
errors when using the SQL procedure.