LOAD TABLE statement
562
Setting CHECK CONSTRAINTS to off disables check constraints. This can
be useful, for example, during database rebuilding. If a table has check
constraints that call user-defined functions that are not yet created, the
rebuild would fail unless this option was set to OFF.
DEFAULTS option By default, DEFAULTS is OFF. If DEFAULTS is
OFF, any column not present in the column list is assigned NULL. If
DEFAULTS is OFF and a non-nullable column is omitted from the column
list, the database server attempts to convert the empty string to the column’s
type. If DEFAULTS is ON and the column has a default value, that value is
used.
DELIMITED BY option The default column delimiter character is a
comma. You can specify an alternative column delimiter by providing a
string. Only the first ASCII character of the string is read. The same
formatting requirements apply as to other SQL strings. In particular, to
specify tab-delimited values, the hexadecimal ASCII code of the tab
character (9) is used. The DELIMITED BY clause is as follows:
...DELIMITED BY ’\x09’ ...
ESCAPE CHARACTER option The default escape character for
characters stored as hexadecimal codes and symbols is a backslash (\), so
\x0A is the linefeed character, for example.
This can be changed using the ESCAPE CHARACTER clause. For example,
to use the exclamation mark as the escape character, you would enter
... ESCAPE CHARACTER ’!’
Only one single-byte character can be used as an escape character.
ESCAPES option With ESCAPES turned on (the default), characters
following the backslash character are recognized and interpreted as special
characters by the database server. New line characters can be included as the
combination \n, other characters can be included in data as hexadecimal
ASCII codes, such as \x09 for the tab character. A sequence of two backslash
characters ( \\ ) is interpreted as a single backslash. A backslash followed by
any character other than n, x, X or \ is interpreted as two separate characters.
For example, \q inserts a backslash and the letter q.
FORMAT option If you choose ASCII, input lines are assumed to be
ASCII characters, one row per line, with values separated by the column
delimiter character. Choosing BCP allows the import of ASE generated BCP
out files containing blobs.
To Next Page
Loading...