Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
Enterprise ReplicationThe HCL OneDB™ Enterprise Replication Guide describes the concepts of data replication using HCL® OneDB® Enterprise Replication, including how to design your replication system, as well as administer and manage data replication throughout your enterprise.
Setting up and managing Enterprise ReplicationAfter you design your replication system, you define it and start replication.
Preparing the Replication EnvironmentThe following topics explain the steps that are required for setting up Enterprise Replication.
Load and unload dataYou can load data into or unload data out of tables in your replication environment in various ways, depending on your circumstances.
UNLOAD and LOAD StatementsThe UNLOAD and LOAD statements allow you to move data within the context of an SQL program.

UNLOAD and LOAD Statements

The UNLOAD and LOAD statements allow you to move data within the context of an SQL program.

If the table contains shadow columns, you must:

Include all shadow columns in your map when you unload the data.
List the columns that you want to load in the INSERT statement and explicitly include the shadow columns in the list when you load your data.

For more information about the UNLOAD and LOAD statements, see the HCL OneDB™ Guide to SQL: Syntax.