Alphabetical list of options
216
There are some cases where a fast TRUNCATE cannot be done:
♦ If there are foreign keys either to or from the table
♦ If the TRUNCATE TABLE statement is executed within a trigger
♦ If the TRUNCATE TABLE statement is executed within an atomic
statement
TRUNCATION_LENGTH option [ISQL]
Controls the truncation of wide columns for displays to fit on a screen.
Integer
30
When SELECT statement results are displayed on the screen, each column of
output is limited to the width of the screen. The TRUNCATION_LENGTH
option is used to reduce the width of wide columns so that more than one
column will fit on the screen. A value of 0 means that columns are not
truncated.
The default TRUNCATION_LENGTH is 30. For character-mode systems,
this is an actual number of characters. For windowing systems,
TRUNCATION_LENGTH is used to estimate an area of the screen to be
used for display since proportional fonts are used.
TSQL_HEX_CONSTANT option
Controls whether hexadecimal constants are treated as binary typed
constants.
ON, OFF
ON
When this option is set to ON, hexadecimal constants are treated as binary
typed constants. To get the historical behavior, set the option to OFF.
TSQL_VARIABLES option
Controls whether the @ sign can be used as a prefix for Embedded SQL host
variable names.
ON, OFF
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description
Function
Allowed values
To Next Page
Loading...