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 Values into Serial ColumnsYou can insert successive numbers or explicit values in a serial column.

Loading Values into Serial Columns

You can insert successive numbers or explicit values in a serial column.

About this task

The database server loads serial columns with either the values from the original data file or values that the database server automatically generates.

If you want the serial column values to be the values from the data file, the INSERT statement does not require special handling. If you want the database server to generate the value automatically, omit the serial column from the INSERT statement. For example, if the first column in the table (col1) is the serial column and you use the following statement, the default mechanism provides the serial value:

INSERT INTO mytable (col2, ...) SELECT ...

If the table is being loaded into multiple partitions, the serial values are incremented in the same sequence as the table fragments.