Chapter 5 Database Options
203
♦
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. If this 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. No column headings are output in this
format.
♦
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.
♦
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 an Interactive SQL
INPUT statement required to
recreate the information in the table.
♦
TEXT The output is a TEXT format file, which prints the results in
columns with the column names at the top and vertical lines separating
the columns. This format is similar to that used to display data in the
Interactive SQL data window.
OUTPUT_LENGTH option [ISQL]
Controls the length used when Interactive SQL exports information to an
external file.
Integer
0 (no truncation)
Function
Allowed values
Default
To Next Page
Loading...