LOAD

The LOAD statement inserts data from an ASCII file into an existing table.

character is a quoted string, specifying a delimiter symbol.

column is the name of a column in table, in parentheses. If you omit the list of column names, the default is all the columns of table.

delimiter is a CHAR or VARCHAR variable containing a symbol.

filename is the specification (within quotation marks) of a file that contains the input data. This can include a pathname. If filename includes a pathname that contains one or more backslash ( \ ) symbols, then you must use a pair of backslashes ( \\ ) to represent each backslash.

file variable is a CHAR or VARCHAR variable containing a filename.

insert variable is a CHAR or VARCHAR variable containing an INSERT clause.

table is the name of a table, synonym, or view. in the current database (as specified by a prior DATABASE statement in the same module),or in a database specified in the table qualifier.

The LOAD statement must include an INSERT statement (either directly or in a variable) to specify where to store the data. LOAD appends the new rows to the specified table, synonym, or view. It does not overwrite existing data. It cannot add a row that has the same key as an existing row. You cannot use the PREPARE statement to preprocess a LOAD statement.

The user who executes the LOAD statement must have Insert privileges for table.

Reference

DATABASE

UNLOAD