|
File name Type the name of the file you are exporting the result set to. Alternatively, you can click Browse to locate a file.
Format Select one of the following output formats:
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).
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.dBase II 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. Column names are truncated to 11 characters, and each row of data in each column is truncated to 255 characters.
dBase III 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. Column names are truncated to 11 characters, and each row of data in each column is truncated to 255 characters.
Excel The output is an Excel 2.1 worksheet. The first row of the worksheet contains column labels (or names if there are no labels defined). Subsequent worksheet rows contain the actual table data.
Fixed The output is fixed format with each column having a fixed width. No column headings are output in this format. 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 with column definitions at the top of the file. Note that a maximum of 128 columns can be output. Column names are truncated to 11 characters. Column names are truncated to 11 characters, and each row of data in each column is truncated to 255 characters.
HTML The output is in the Hyper Text Markup Language format.
Lotus 1-2-3 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 Statements The output is an Interactive SQL INPUT statement required to recreate the information in the table.
XML The output is an XML file encoded in UTF-8 and containing an embedded DTD. Binary values are encoded in CDATA blocks with the binary data rendered as 2-hex-digit strings. The INPUT statement does not accept XML as a file format.
Encoding Specify the code page that is used to write the file. You can only specify this option if you have selected the ASCII format. You can specify the encoding to be used, or if you select (Default), the default encoding for the computer Interactive SQL is running on is used.
Escape text data When you select this option, characters following the escape character are recognized and interpreted as special characters by the database server. The default escape character is the backslash (\). 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.
Escape character You can specify the escape character for characters stored as hexadecimal codes. The default escape character is the backslash (\).