Import and Export Method Selection

Sybase IQ offers you a choice of methods for adding, changing, or deleting data.

The IQ data extraction facility exports data in binary or ASCII format, which can be loaded into another database. Use this facility for high-volume data movement, or when you need an output file that can be used for loads.

From Interactive SQL, you can export data to another database in a variety of formats, or produce a text file as output. See the next section for a list of formats and how to select them. You can also redirect the output of any command.

Note: Sybase IQ supports BCP through the LOAD TABLE FORMAT BCP option. Sybase IQ also supports bulk loading of remote data using the LOAD TABLE USING CLIENT FILE option. See Reference: Statements and Options.

You can perform a BCP into a SQL Anywhere table, then transfer the contents to Sybase IQ; however, the transfer of rows is executed one row at a time. Sybase IQ does not support the Open Client Bulk-Library (blklib) routines, so BCP, which uses the Open Client Bulk-Library, does not work in bulk-load mode. (Bulk-Library/C provides routines that allow Client-Library and Server-Library applications to use Adaptive Server Enterprise’s bulk copy interface for high-speed data transfer.) The BCP format in both Sybase IQ and Adaptive Server Enterprise supports a leading blank before a single digit that is part of a date.

Related reference
The Extract Options