The LOAD TABLE statement imports data from files row by row. Both ASCII and binary input files are supported, with either fixed-length fields or variable-length fields ended by a delimiter.
The INSERT statement moves data into a Sybase IQ table either from a specified set of values, or directly from tables.
For output file formats supported by Interactive SQL, see Utility Guide > dbisql > SQL Statements for Interactive SQL > OUTPUT Statement [Interactive SQL].
The IQ data extraction facility exports data in binary or ASCII format.