Contents Index SET statement SET CONNECTION statement [Interactive SQL] [ESQL]

ASA SQL Reference
  SQL Statements

SET statement [T-SQL]


Description 

Use this statement to set database options for the current connection in an Adaptive Server Enterprise-compatible manner.

Syntax 

SET option-name option-value

Usage 

The available options are as follows:

Option name Option value
ANSINULL ON | OFF
ANSI_PERMISSIONS ON | OFF
CLOSE_ON_ENDTRANS ON | OFF
DATEFIRST 1 | 2 | 3 | 4 | 5 | 6 | 7
QUOTED_IDENTIFIER ON | OFF
ROWCOUNT integer
SELF_RECURSION ON | OFF
STRING_RTRUNCATION ON | OFF
TEXTSIZE integer
TRANSACTION ISOLATION LEVEL 0 | 1 | 2 | 3

Database options in Adaptive Server Anywhere are set using the SET OPTION statement. However, Adaptive Server Anywhere also provides support for the Adaptive Server Enterprise SET statement for options that are particularly useful for compatibility.

The following options can be set using the Transact-SQL SET statement in Adaptive Server Anywhere as well as in Adaptive Server Enterprise:

In addition, the SET statement is allowed by Adaptive Server Anywhere for the PREFETCH option, for compatibility, but has no effect.

Permissions 

None.

Side effects 

None.

See also 

SET OPTION statement

Setting options for Transact-SQL compatibility

Compatibility options

Standards and compatibility 

Contents Index SET statement SET CONNECTION statement [Interactive SQL] [ESQL]