After creating tables and indexing their columns, you can fill them with data. You can load your Sybase IQ database using any of the following:
The ODBC programming interface
Embedded SQL programming interface
The Open Client programming interface
dbisql
dbislqc
Sybase Central
For details about the programming interfaces listed above, see the Utility Guide. If a client application has been written to perform the load, use the appropriate programming interface.
You can use Interactive SQL (dbisql) to insert data manually. Interactive SQL (DBISQL) is an interface available on all supported platforms. See the Utility Guide to learn how to run dbisql.
Use these SQL commands to load a table:
INSERT FROM SELECT loads information from a database on your system or an attached database.
INSERT VALUES inserts data “manually” into specified table columns.
LOAD inserts data from files. It can be used to insert binary data from backups and upgrades. To insert data from files, use the LOAD command instead of INSERT. Sybase IQ supports loading from both ASCII and binary files and supports both fixed-length and variable-length formats.
To load large amounts of data, most users create command files. See Using Interactive SQL (dbisql) in the Utility Guide.
Syntax and examples for the INSERT and LOAD commands are in Reference: Statements and Options.
To add a row to a table using Sybase Central:
In Folder view, open the Tables folder, click the table you want to update, then click the Data tab in the right pane. Right-click a row, and choose Add.
In Tasks view, double-click the Tables folder, choose the table you want to update, then click the Data tab. Right-click a row, and choose Add.
