Chapter 9 SQL Statements
575
♦
ASCII The output is an ASCII format file with one row per line in the
file. All values are separated by commas, and strings are enclosed in
apostrophes (single quotes). The delimiter and quote strings can be
changed using the DELIMITED BY and QUOTE clauses. If ALL is
specified in the QUOTE clause, all values (not just strings) will be
quoted.
Three other special sequences are also used. The two characters \n
represent a newline character, \\ represents a single \, and the sequence
\xDD represents the character with hexadecimal code DD. This is the
default output format.
If you are exporting Java methods that have string return values, you
must use the HEXADECIMAL OFF clause.
♦
DBASEII The output is a dBASE II format file with the column
definitions at the top of the file. Note that a maximum of 32 columns can
be output. Also, note that columns longer than 255 characters will be
truncated in the file.
♦
DBASEIII The output is a dBASE III format file with the column
definitions at the top of the file. Note that a maximum of 128 columns
can be output. Also, note that columns longer than 255 characters will be
truncated in the file.
♦
FIXED The output is fixed format with each column having a fixed
width. The width for each column can be specified using the COLUMN
WIDTH clause. No column headings are output in this format.
If the COLUMN WIDTH clause is omitted, the width for each column is
computed from the data type for the column, and is large enough to hold
any value of that data type. The exception is that LONG VARCHAR
and LONG BINARY data defaults to 32 kb.
♦
FOXPRO The output is a FoxPro format file (the FoxPro memo field is
different than the dBASE memo field) with the column definitions at the
top of the file. Note that a maximum of 128 columns can be output.
Also, note that columns longer than 255 characters will be truncated in
the file.
♦
HTML The output is in the Hyper Text Markup Language format.
♦
LOTUS The output is a Lotus WKS format worksheet. Column names
will be put as the first row in the worksheet. Note that there are certain
restrictions on the maximum size of Lotus WKS format worksheets that
other software (such as Lotus 1-2-3) can load. There is no limit to the
size of file Interactive SQL can produce.
♦
SQL The output is a Interactive SQL INPUT statement required to
recreate the information in the table.
To Next Page
Loading...