Zipping files for Client Access download

["Andre Odendaal" <Andre.Odendaal@xxxxxxxxxxx>]

Hi
 We are having some problems using PKZIP. Basically what we are trying to
do is zip a huge file on the AS400  and download to SQL server using Client
Access. The file can take as long as 3 hours on Month-end to download,
which is why we want to try compressing it. On the SQL server side we are
trying to unzip the file but are coming up with error messages related to
data type. I assume the data conversion normally done by Client Access is
not being done and that ASCII conversion should be done before the file is
Zipped. Does anyone know of  any procedures that do this, or have any
advice?

Thanks
Andre


*******************************************************************
The e-mail and any attachments are confidential. They may contain
priviledged information and are intended for the named addressee(s)
only. If you are not the intended recipient, please notify us
immediately and do not disclose, distribute, or retain this e-mail
or any part of it.
Unless expressly stated, opinions in this e-mail are those of the
individual sender and not of the FIMAT Group. We believe but do not
warrant that this e-mail and any attachments are virus free. 
You must therefore take full responsibility for virus checking. 
The FIMAT Group reserve the right to monitor e-mail communications
through its networks.   

Fimat International Banque S.A. (UK Branch) is regulated by the SFA
for the conduct of investment business in the UK.
Member of LIFFE and LSE. The information, opinions, estimates and
forecasts contained in this document have been arrived at or obtained
from public sources believed to be reliable and in good faith which 
has not been independently verified and no warranty, express
or implied, is made as to their accuracy, completeness or correctness.
This document is not an offer to sell or a solicitation to acquire
or dispose of an interest in securities. 

If you have received this transmission in error, please telephone
+44 020 7676 8999 immediately so that we can arrange for its return.
*******************************************************************
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---