The INSERT statement allows you to
insert data without first putting it into a flat file.
Using this command, you can either:
Insert a specified set of values row by row
Insert directly from database tables
Inserting Specified Values Row by Row
To add specified values to a table row by row, use Syntax 1 for the INSERT statement. SAP Sybase IQ inserts the first value you specify into the first column you specify, the second value you specify into the second column, and so on.