Home | Previous Page | Next Page   Disk, Memory, and Process Management > Managing Disk Space >

Loading 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
ESQL/C programs Yes Yes IBM Informix ESQL/C Programmer's Manual
onload utility No No IBM Informix Migration Guide
onpladm utility Yes, deluxe mode Yes, deluxe mode IBM Informix Server Administrator
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.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]