INSERT clause

INSERT clause contains the identifier of a table or tables into which the values should be inserted. This clause supports the syntax of the independent SQL INSERT statement, however it is not possible to include optional clauses of the independent INSERT statement (i.e. VALUES, SELECT, EXECUTE PROCEDURE clauses) into the INSERT clause of the LOAD statement.

 

The INSERT INTO keywords can be followed by the table name (with or without table qualifiers) if the values in the input file match the columns of such table in order, number and data types.

 

You must explicitly specify the column names within the parentheses, if:

• The values are inserted not in every table column
• The order of values does not match the order of columns

LOAD FROM "/source/unl/ord_info" DELIMITER "!" INSERT INTO order_info (ord_num, items, number)