Input and Output Data Formats

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 SAP Sybase IQ table either from a specified set of values, or directly from tables.

OUTPUT statement file formats supported by Interactive SQL include:

The IQ data extraction facility exports data in binary or ASCII format.

Parent topic: Import and Export Overview
Related concepts
Import and Export Method Selection
Permissions for Modifying Data
Schedule Database Updates