Usage Notes - MultiLoad

Tables cannot be created with invalid column names, and any nonstandard column name produces an error condition, depending on the nature of the divergence from the standard. The errors are:

• Embedded blanks cause a syntax error, depending on the non-blank contents of the name.
• Invalid characters cause an invalid name error.
• Reserved words cause a syntax error that mentions invalid use of the reserved word.

Avoid using the .TABLE command if the FIELD names contain multi-byte characters. Instead, use FIELD commands, enclosing multi-byte field names in double-quotes. For example:

.FIELD “
”         *     INTEGER;

This method of specifying record layout fields assumes each field, as defined by the data description of the corresponding column of tableref, is contiguous with the previous one, beginning at the next-available character position beyond any previous field specifications for the input records. The fields must appear in the order defined for the columns of the table.

The object identified by the tableref parameter must be a table. It need not appear as a parameter of the BEGIN MLOAD or BEGIN DELETE MLOAD command, but must either be the owner of the object or have at least one privilege on it.

If specified as an unqualified table name, the current default database qualifies it.