Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE EXTERNAL TABLE StatementUse the CREATE EXTERNAL TABLE statement to define an external source that is not part of your database to load and unload data for your database.
External Table Examples The examples in this section illustrate different ways to load and unload data using external tables.
Loading Data from External Tables into HCL OneDB™To load data, you define the external data as an external table and then insert the data into the database.

Loading Data from External Tables into HCL OneDB

To load data, you define the external data as an external table and then insert the data into the database.

The database server performs express-mode loads and deluxe-mode loads. You can perform express-mode loads only when the table is type RAW and does not have any active indexes. The database server allows constraint checking for both load modes.

Express® mode provides the highest performance during a load.

Deluxe mode combines fast parallel loading with evaluation of indexes and unique constraints, and is more efficient in the following situations:

The cost of rebuilding an index is too high for the amount of data that you are loading.
You want to use the empty space from deleted rows in the table that you are loading. database

If the table receiving the rows from the external table is a STANDARD table (that is, a database table that was not created by the CREATE TEMP TABLE or CREATE RAW TABLE statement), the EXPRESS keyword has no effect, and the table is loaded in DELUXE mode. The database server does not issue an exception when it ignores the EXPRESS keyword in load operations where the receiving table is not a RAW table.