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.
