Chapter 9 SQL Statements
563
QUOTES option With QUOTES turned on (the default), the LOAD
statement expects strings to be enclosed in quote characters. The quote
character is either an apostrophe (single quote) or a quotation mark (double
quote). The first such character encountered in a string is treated as the quote
character for the string. Strings must be terminated by a matching quote.
With quotes on, column delimiter characters can be included in column
values. Also, quote characters are assumed not to be part of the value.
Therefore, a line of the form
’123 High Street, Anytown’,(715)398-2354
is treated as two values, not three, despite the presence of the comma in the
address. Also, the quotes surrounding the address are not inserted into the
database.
To include a quote character in a value, with QUOTES on, you must use two
quotes. The following line includes a value in the third column that is a
single quote character:
’123 High Street, Anytown’,’(715)398-2354’,’’’’
STRIP option With STRIP turned on (the default), trailing blanks are
stripped from values before they are inserted. To turn the STRIP option off,
the clause is as follows:
...STRIP OFF ...
Trailing blanks are stripped only for non-quoted strings. Quoted strings
retain their trailing blanks. Leading blanks are trimmed, regardless of the
STRIP setting, unless they are enclosed in quotes.
WITH CHECKPOINT option The default setting is OFF. If set to ON, a
checkpoint is issued after successfully completing and logging the statement.
If WITH CHECKPOINT ON is not specified, and the database requires
automatic recovery before a CHECKPOINT is issued, the data file used to
load the table must be present for the recovery to complete successfully. If
WITH CHECKPOINT ON is specified, and recovery is subsequently
required, recovery begins after the checkpoint, and the data file need not be
present.
To Next Page
Loading...