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 |
|---|---|---|---|
| LOAD statement | Yes | Yes | LOAD statement in the HCL OneDB™ Guide to SQL: Syntax |
| dbload utility | Yes | Yes | HCL® OneDB Migration Guide |
| dbimport utility | Yes | Yes | HCL OneDB Migration Guide |
| programs | Yes | Yes | HCL OneDB® ESQL/C Programmer's Manual |
| Insert MERGE, using an EXTERNAL source table | Yes | Yes | HCL OneDB Guide to SQL: Syntax |
| onload utility | No | No | HCL OneDB Migration Guide |
| onpladm utility | Yes, deluxe mode | Yes, deluxe mode | HCL OneDB High-Performance Loader User's Guide |
| High-Performance Loader (HPL) | Yes, deluxe mode | Yes, deluxe mode | HCL OneDB 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.