LOAD TABLE Supports Loading from Compressed .gzip or .gz Files

The FROM clause of the LOAD TABLE statement now supports loading external files compressed with .gzip file compression.

The LOAD TABLE statement can load compressed client and server files only in gzip format. Any file with an extension ".gz" or ".gzip" is assumed to be a compressed file. Named pipes or secondary files are not supported during a compressed file load. Compressed files and uncompressed files can be specified in the same LOAD TABLE statement. Each compressed file in a load is processed by one thread.

ON FILE ERROR CONTINUE is not supported for compressed file loading.

See this topic in the SAP Sybase IQ 16.0 SP2 documentation:

LOAD TABLE Statement in Reference: Statements and Options

Related concepts
Read This First: Helpful Hints Before You Start Using SAP Sybase IQ 16