To meet your needs, we constantly work to improve Querix products.
This means that Lycia documentation is developing as well.
In case you have found a certain dissonance between the provided information and the actual behavior of Lycia 3 and/or your applications, please, let us know about this via documentation@querix.com so that we can introduce the necessary changes to our documentation.
Thank you for your attention and cooperation.
To insert the data stored in a file into a database table, the LOAD statement is used.
|
Element |
Description |
|
Input File |
A character expression that returns the name of the input file and its relative path if necessary |
|
Delimiter |
is a quoted string (or a CHAR, STRING, or VARCHAR variable) containing a delimiter symbol |
|
Variable |
A CHAR, STRING or VARCHAR variable containing an INSERT clause. |
|
INSERT Clause |
A CHAR, STRING, or VARCHAR variable containing an INSERT clause. |
The LOAD statement must contain the INSERT clause to indicate the table to which the data should be loaded. The LOAD statement adds new rows to the specified table or view, it does not erase or delete the data already existing in this table or view. The LOAD statement cannot be used in the PREPARE statement. A row that has the same key as an existing row cannot be added to a table.
To execute the LOAD statement the user must have the insert privileges for the specified table.