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.