Alphabetical list of options
176
Controls the Transact-SQL transaction mode. In Unchained mode
(CHAINED = OFF), each statement is committed individually unless an
explicit BEGIN TRANSACTION statement is executed to start a transaction.
In chained mode (CHAINED = ON) a transaction is implicitly started before
any data retrieval or modification statement.
CHAR_OEM_TRANSLATION option [ISQL]
Controls whether ANSI-to-OEM code page translation is carried out.
ON, OFF, DETECT
DETECT
Each time Interactive SQL connects to a database or uses SET
CONNECTION, it determines the setting of Char_OEM_Translation.
If the option is set to ON or OFF, translation is set accordingly. If the option
is set to DETECT (the recommended and default setting), Interactive SQL
fetches the collation label from the database and examines it. If the collation
label starts with a string that generally indicates an ANSI code page, then
Interactive SQL turns translation off.
The strings that indicate ANSI code pages are as follows:
♦ WIN_
♦ ISO_
♦ SJIS
♦ EUC_
♦ UTF
♦ EBCDIC
♦ 813
♦ 819
For all other prefixes, translation is turned on. When the option is set to
DETECT, Interactive SQL displays a message in the status window
indicating the collation label and the display translation setting.
Description
Function
Allowed values
Default
Description
To Next Page
Loading...