Alphabetical list of options
202
first-row or all-rows
first-row
By default, Adaptive Server Anywhere chooses an access plan that is
intended to reduce the time to fetch the first row of output, possibly at the
expense of total retrieval time. In particular, Adaptive Server Anywhere
typically avoids materializing results if possible in order to reduce the time to
return the first row.
The OPTIMIZATION_GOAL option controls whether Adaptive Server
Anywhere optimizes for response time or total resource consumption. If the
option is set to all-rows (as opposed to the default first-row), then Adaptive
Server Anywhere optimizes the total retrieval time instead of the time for the
first row. In this case, Adaptive Server Anywhere does not avoid
materialization unless the estimated total execution time is longer than a plan
without materialization.
Setting OPTIMIZATION_GOAL to all-rows may be appropriate for
applications that require the entire result set before processing, such as
PowerBuilder DataWindow applications.
OUTPUT_FORMAT option [ISQL]
Sets the output format for the data retrieved by the SELECT statement and
redirected into a file, or output using the OUTPUT statement.
String. See below for allowed values.
ASCII
The valid output formats are:
♦
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, then 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 backslash character,
and the sequence \xDD represents the character with hexadecimal code
DD.
Allowed values
Default
Description
Function
Allowed values
Default
Description
To Next Page
Loading...