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.dll - 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.dll - 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.dll - 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: winnt_prompt> cd !SASROOT/core/sasexe winnt_prompt> copy sassqxo.dll sassqxo.org winnt_prompt> copy sassqxs.dll sassqxs.org winnt_prompt> copy sassqxu.dll sassqxu.org 2) Download the new files that fix the PROC SQL 2 GIG problem. winnt_prompt> ftp ftp.sas.com userid: anonymous password: ftp> binary ftp> get README.S2G README.S2G ftp> get sassqxo.dll sassqxo.s2g ftp> get sassqxs.dll sassqxs.s2g ftp> get sassqxu.dll sassqxu.s2g ftp> quit winnt_prompt> cp sassqxo.s2g sassqxo.dll winnt_prompt> cp sassqxs.s2g sassqxs.dll winnt_prompt> cp sassqxu.s2g sassqxu.dll NOTE: Be sure the download was successful... verify the file sizes of the modules are as follows: FOR WIN/NT: sassqxo.dll -- 40768 bytes or 40 kb sassqxs.dll -- 42640 bytes or 42 kb sassqxu.dll -- 48160 bytes or 47 kb FOR WIN 95: sassqxo.dll -- 40768 bytes or 40 kb sassqxs.dll -- 42640 bytes or 42 kb sassqxu.dll -- 48160 bytes or 47 kb FOR OS/2: sassqxo.dll -- 50345 bytes or 49 kb sassqxs.dll -- 51607 bytes or 50 kb sassqxu.dll -- 55118 bytes or 54 kb 3) Be sure you understand that if you install the MAINTENANCE Release TS050 or higher that 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: winnt_prompt> cp sassqxo.s2g sassqxo.dll winnt_prompt> cp sassqxs.s2g sassqxs.dll winnt_prompt> cp sassqxu.s2g sassqxu.dll 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.