You can load data into an existing table in the following ways.
| Method to Load Data | TEXT or BYTE Data | Reference |
|---|---|---|
| DB-Access LOAD statement | Yes | LOAD statement in the IBM Informix: Guide to SQL Syntax |
| dbload utility | Yes | IBM Informix: Migration Guide |
| dbimport utility | No | IBM Informix: Migration Guide |
| IBM Informix ESQL/C programs | Yes | IBM Informix: ESQL/C Programmer's Manual |
| From external tables | Yes | Chapter on loading with external tables in the IBM Informix: Administrator's Reference |