Alphabetical list of options
178
When CLOSE_ON_ENDTRANS is set to OFF, cursors are not closed at
either a commit or a rollback, regardless of the
ANSI_CLOSE_CURSORS_AT_ROLLBACK option setting or whether the
cursor was opened WITH HOLD or not.
Setting this to OFF provides Adaptive Server Enterprise compatible
behavior.
COMMAND_DELIMITER option [ISQL]
Sets the string that indicates the end of a statement in Interactive SQL.
String
Semi-colon (;)
You can specify a command delimiter to indicate the end of a SQL
statement. This command delimiter can be any sequence of characters
(including numbers, letters, and punctuation), but it cannot contain
embedded blanks. As well, it can contain a semicolon, but only as the first
character.
If the command delimiter is set to a string beginning with a character that is
valid in identifiers, the command delimiter must be preceded by a space.
This command delimiter is case sensitive. You should enclose the new
command delimiter in single quotation marks.
SET OPTION COMMAND_DELIMITER=’;;’
COMMIT_ON_EXIT option [ISQL]
Controls behavior when Interactive SQL disconnects or terminates.
ON, OFF
ON
Controls whether a COMMIT or ROLLBACK is done when you leave
Interactive SQL. When COMMIT_ON_EXIT is set to ON, a COMMIT is
done; otherwise a ROLLBACK is done.
COMPRESSION option
Set the level of compression for SQL Remote messages.
Integer, from -1 to 9
Function
Allowed values
Default
Description
Example
Function
Allowed values
Default
Description
Function
Allowed values
To Next Page
Loading...