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 IBM® 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 IBM 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.

Copyright© 2018 HCL Technologies Limited