Client Interaction properties

ClientDecimalSeparator

select @@ClientDecimalSeparator

set ClientDecimalSeparator char

GatewayCompatible

select @@GatewayCompatible

No set statement

MaxResultSize

select @@MaxResultSize

set MaxResultSize integer

MaxRowsReturned

select @@MaxRowsReturned

set MaxRowsReturned integer

MaxSvcConnections

select @@MaxSvcConnections

No set statement

Quoted_Identifier

select @@quoted_identifier

set Quoted_Identifier {no | yes}

SendWarningMessages

select @@SendWarningMessages

set SendWarningMessages {no | yes}

ServiceDescription

select @@ServiceDescription

No set statement

SvclibDescription

select @@SvclibDescription (This global variable applies to the DB2 access service library as a whole.)

No set statement

TextSize

select @@TextSize

set TextSize integer

TransactionMode

select @@TransactionMode

set TransactionMode {short | long}

Version

select @@Version

No set statement

Returns the current version string in effect. To find the default version, see sp_helpserver.