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 database, use the SQL statement INSERT with a SELECT statement clause.
To remove specific rows from a table, use the DELETE statement.
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, iq_bcp,
an open-client based utility that copies a database table to or
from an operating system file in a user-specified format.
You can perform a BCP into an Anywhere table and then transfer the contents to Sybase IQ; however, the transfer of rows from 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, doesn’t work in load mode. Both Sybase IQ and Adaptive Server Enterprise BCP format supports a blank when one digit is in the date.
