SAP 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 (including a table
residing in another 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, use the UPDATE statement.
The IQ data extraction facility exports data in binary or ASCII format, which you
can then load 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. You can also redirect the output
of any command.
Note: SAP Sybase IQ supports BCP through the
LOAD TABLE FORMAT BCP
option. You can directly perform a BCP into an IQ table. SAP Sybase IQ also supports bulk
loading of remote data using the LOAD TABLE
USING CLIENT FILE option.