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 HCL Informix Guide to SQL: Syntax |
| dbload utility | Yes | Yes | IBM Informix Migration Guide |
| dbimport utility | Yes | Yes | IBM Informix Migration Guide |
| Informix® ESQL/C programs | Yes | Yes | HCL Informix Enterprise Replication Guide |
| Insert MERGE, using an EXTERNAL source table | Yes | Yes | HCL Informix Guide to SQL: Syntax |
| onload utility | No | No | IBM Informix Migration Guide |
| onpladm utility | Yes, deluxe mode | Yes, deluxe mode | IBM Informix High-Performance Loader User's Guide |
| High-Performance Loader (HPL) | Yes, deluxe mode | Yes, deluxe mode | IBM Informix High-Performance Loader User's 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.