Alphabetical list of options
186
When set to binary, Interactive SQL does no data conversion.
DIVIDE_BY_ZERO_ERROR option
Controls the reporting of division by zero.
ON, OFF
ON
This option indicates whether division by zero is reported as an error. If the
option is set ON, then division by zero results in an error with SQLSTATE
22012.
If the option is set OFF, division by zero is not an error. Instead, a NULL is
returned.
ECHO option [ISQL]
Controls whether statements are echoed before they are executed.
ON, OFF
ON
This option is most useful when you use the READ statement to execute a
Interactive SQL command file.
ESCAPE_CHARACTER option
This option is reserved for system use. Do not change the setting of this
option.
EXTENDED_JOIN_SYNTAX option
Controls whether queries with an ambiguous syntax for multi-table joins are
allowed, or reported as an error.
ON, OFF
ON
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description
Function
Allowed values
Default
To Next Page
Loading...