ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-92
SET
SET
Use SET to set query-processing options for the duration of a work session.
The SET statement has the following syntax:
ALTNAMES
is not supported. If included in a program used with the NonStop ODBC Server, an
error message is generated.
ARITHABORT
is not supported. In the NonStop ODBC Server, ARITHABORT is always ON and
cannot be reset. If included in a program used with the NonStop ODBC Server, an
error message is generated.
ARITHIGNORE
is not supported. If included in a program used with the NonStop ODBC Server, an
error message is generated.
BACKGROUND
is not supported. If included in a program used with the NonStop ODBC Server, an
error message is generated.
CONTROL
is not supported. If included in a program used with the NonStop ODBC Server, an
error message is generated.
NOCOUNT
is not supported. If included in a program used with the NonStop ODBC Server, an
error message is generated.
SET { { ALTNAMES } { OFF } }
{ { ARITHABORT } { ON } }
{ { ARITHIGNORE } }
{ { BACKGROUND } }
{ { CONTROL } }
{ { NOCOUNT } }
{ { NOEXEC } }
{ { OFFSETS { { keyword-list } } }
{ { PARSEONLY } }
{ { PROCID } }
{ { SHOWPLAN } }
{ { STATISTICS IO } }
{ { STATISTICS TIME } }
{ ROWCOUNT number }
{ TEXTSIZE number, }