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”.
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 |