Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
Disk, memory, and process management
Manage disk spaceYou can use several utilities and tools to manage disk spaces and the data that the database server controls.
Load data into a table

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 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

Important: The database server does not contain any mechanisms for compressing TEXT and BYTE data after the data has been loaded into a database.