Sybase IQ offers you a choice of methods for adding, changing, or deleting data.
For efficient bulk loading of tables from flat files, use the SQL statement LOAD TABLE.
To insert specified values into a table row by row, use the SQL statement INSERT with the VALUES option.
To insert rows selected from a table, use the SQL statement INSERT with a SELECT statement clause.
To insert rows from a table residing in another database, use the SQL statement INSERT with a LOCATION statement clause.
To remove specific rows from a table, use the DELETE statement. The TRUNCATE statement initializes a table to 0 rows.
To change existing rows in a table, you can also use the UPDATE statement.
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. See the section “Data extraction options” for details and advantages of this feature.
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.
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 “Direct loading of data from clients” and LOAD
TABLE statement in Chapter
1, “SQL Statements” in 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’s bulk copy interface for high-speed data transfer.) The BCP format in both Sybase IQ and Adaptive Server supports a leading blank before a single digit that is part of a date.
