To speed data loading into Sybase IQ, create data files in Sybase IQ binary format, then load this data into Sybase IQ using the FORMAT BINARY and BINARY column specification clauses of LOAD TABLE.
You can find instructions for using LOAD TABLE in Reference: Statements and Options.
Create data files with these binary formats to load into columns with the corresponding data types. In most cases, Sybase IQ uses the platform-specific binary format. The following data types are exceptions that use binary formats that are specific to Sybase IQ:
DATE
TIME
DATETIME
NUMERIC
