Load data into a table
You can load data into an existing table in the following
ways.
Method to load data | TEXT or BYTE data | CLOB or BLOB data | Reference |
---|---|---|---|
DB-Access LOAD statement | Yes | Yes | LOAD statement in the Informix® Guide to SQL: Syntax |
dbload utility | Yes | Yes | Informix® Migration Guide |
dbimport utility | Yes | Yes | Informix® Migration Guide |
Informix® ESQL/C programs | Yes | Yes | Informix® ESQL/C Programmer's Manual |
Insert MERGE, using an EXTERNAL source table | Yes | Yes | Informix® Guide to SQL: Syntax |
onload utility | No | No | Informix® Migration Guide |
Important: The database server does not contain
any mechanisms for compressing TEXT and BYTE data after the data has
been loaded into a database.