We are loading data from Netezza into a Netezza external table (file on unix).
The .txt file is compressed into a .gz file using gzip, then ftp'd to a windows 2008 server & decompressed using gunzip (on the windows server).
When running a gunzip command on Windows, the command fails with an 'unexpected end of file' error:
Creating a .txt file straight from vi on unix, gzip it, then ftp'ng to windows followed by gunzip all works great.
Thoughts on what could be added to the External Table definition or ?