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 DBISQL 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.
For details, 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 and then transfer the contents to Sybase IQ; however, the transfer of rows from SQL Anywhere to Sybase IQ is executed one row at a time. Sybase IQ does not support BLKLIB, so BCP, which uses Open Client’s Bulk-Library, does not work in bulk-load mode. Both Sybase IQ and Adaptive Server Enterprise BCP format supports a blank when one digit is in the date.
