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

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

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.