Keywords for server options

Table 2-37 lists the keywords for configuring the server options for a connection.

Application calls to ct_options always override equivalent settings in the configuration file.

The keywords for setting server options are listed below. For descriptions of what each option controls, see “Options”.

Table 2-37: Configuration file keywords for server options

Keyword

Legal value

CS_OPT_ANSINULL

CS_TRUE or CS_FALSE

CS_OPT_ANSIPERM

CS_TRUE or CS_FALSE

CS_OPT_ARITHABORT

CS_TRUE or CS_FALSE

CS_OPT_ARITHIGNORE

CS_TRUE or CS_FALSE

CS_OPT_AUTHOFF

A string value

CS_OPT_AUTHON

A string value

CS_OPT_CHAINXACTS

CS_TRUE or CS_FALSE

CS_OPT_CURCLOSEONXACT

CS_TRUE or CS_FALSE

CS_OPT_CURREAD

A string valu.

CS_OPT_CURWRITE

A string value

CS_OPT_DATEFIRST

CS_OPT_SUNDAY, CS_OPT_MONDAY, CS_OPT_TUESDAY, CS_OPT_WEDNESDAY, CS_OPT_THURSDAY, CS_OPT_FRIDAY, or CS_OPT_SATURDAY

CS_OPT_DATEFORMAT

CS_OPT_FMTMDY, CS_OPT_FMTDMY, CS_OPT_FMTYMD, CS_OPT_FMTYDM, CS_OPT_FMTMYD, or CS_OPT_FMTDYM

CS_OPT_FIPSFLAG

CS_TRUE or CS_FALSE

CS_OPT_FORCEPLAN

CS_TRUE or CS_FALSE

CS_OPT_FORMATONLY

CS_TRUE or CS_FALSE

CS_OPT_GETDATA

CS_TRUE or CS_FALSE

CS_OPT_IDENTITYOFF

A string value

CS_OPT_IDENTITYON

A string value

CS_OPT_ISOLATION

CS_OPT_LEVEL0, CS_OPT_LEVEL1, or CS_OPT_LEVEL3

CS_OPT_NOCOUNT

CS_TRUE or CS_FALSE

CS_OPT_NOEXEC

CS_TRUE or CS_FALSE

CS_OPT_PARSEONLY

CS_TRUE or CS_FALSE

CS_OPT_QUOTED_IDENT

CS_TRUE or CS_FALSE

CS_OPT_RESTREES

CS_TRUE or CS_FALSE

CS_OPT_ROWCOUNT

An integer value

CS_OPT_SHOWPLAN

CS_TRUE or CS_FALSE

CS_OPT_SORTMERGE

CS_TRUE or CS_FALSE

CS_OPT_STATS_IO

CS_TRUE or CS_FALSE

CS_OPT_STATS_TIME

CS_TRUE or CS_FALSE

CS_OPT_TEXTSIZE

An integer value

CS_OPT_TRUNCIGNORE

CS_TRUE or CS_FALSE