Alphabetical list of options
212
When you set the STATISTICS option to 0, no information appears in the
Messages pane after you execute a SQL statement. When you set the option
to any other number, both the execution time and the default plan appear in
the Messages pane after you execute a statement. The number you specify is
also used as the default height (in lines) of the Messages pane.
STRING_TRUNCATION option
Determines whether an error is raised when an INSERT or UPDATE
truncates a CHAR or VARCHAR string.
ON, OFF
OFF
If the truncated characters consist only of spaces, no exception is raised. The
setting of ON corresponds to ANSI/ISO SQL/92 behavior. When it is set to
OFF, the exception is not raised and the character string is silently truncated.
SUBSCRIBE_BY_REMOTE option
Controls interpretation of NULL or empty-string SUBSCRIBE BY values.
ON, OFF
ON
When the option is set to ON, operations from remote databases on rows
with a SUBSCRIBE BY value that is NULL or an empty string assume that
the remote user is subscribed to the row. When it is set to OFF, the remote
user is assumed not to be subscribed to the row.
THREAD_COUNT option
Historical
Integer
Not applicable
This option is now ignored by the server. For Version 6 you should use the
-
gn
server command-line option to set the maximum number of requests that
the server handles simultaneously.
$ For information on the command-line switch, see "The database server"
on page 14.
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description