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™.
LOAD statementUse the LOAD statement to insert data from an operating-system file into an existing table or view.
INSERT INTO ClauseUse the INSERT INTO clause to specify the table, synonym, or view in which to load the new data.

INSERT INTO Clause

Use the INSERT INTO clause to specify the table, synonym, or view in which to load the new data.

You must specify the column names only if one of the following conditions is true:

You are not loading data into all columns.
The input file does not match the default order of the columns (the order specified when the table was created).

The INTO clause cannot specify a table object that the CREATE EXTERNAL TABLE statement defined.

The following example identifies the price and discount columns as the only columns in which to add data. The example uses Windows™ file naming conventions.

LOAD FROM 'C:\tmp\prices' DELIMITER ','
   INSERT INTO norman.worktab(price,discount)