Access Service User's Guide DirectConnect for AS/400

Configuration Property

Global Variable and set Statement

DefaultClientCodeset

select @@DefaultClientCodeset

set DefaultClientCodeset codeset

DefaultTargetCodeset

select @@DefaultTargetCodeset

No set statement

Configuration Property

Global Variable and set Statement

Allocate

select @@Allocate

set Allocate {connect | request}

IsolationLevel

select @@IsolationLevel

No set statement

SQLTransformation

select @@SQLTransformation

set SQLTransformation {passthrough | sybase}

StopCondition

select @@StopCondition

set StopCondition {error | none | warning}

TargetDecimalSeparator

select @@TargetDecimalSeparator

No set statement

Configuration Property

Global Variable and set Statement

CSPCatalogQualifier

select @@CSPCatalogQualifier

set CSPCatalogQualifier catalogqualifier

CSPDBName

select @@CSPDBName

set CSPDBName {NULL | dbname}

CSPIncludeSystem

select @@CSPIncludeSystem

set CSPIncludeSystem {no | yes}

CSPIncludeTable

select @@CSPIncludeTable

set CSPIncludeTable {yes | no}

CSPIncludeView

select @@CSPIncludeView

set CSPIncludeView {yes | no}

CSPQualByDBName

select @@CSPQualByDBName

set CSPQualByDBName {no | yes}

DatatypeInfo

select @@DatatypeInfo

set DatatypeInfo {transact | target}

Configuration Property

Global Variable and set Statement

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 {on| off}

SendWarningMessages

select @@SendWarningMessages

set SendWarningMessages {no | yes}

ServiceDescription

select @@ServiceDescription

No set statement

SvclibDescription

select @@SvclibDescription (This global variable applies to the 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 .

Configuration Property

Global Variable and set Statement

BinaryResults

select @@BinaryResults

set BinaryResults {binary | char}

DateResults

select @@DateResults

set DateResults {datetime | datetime4 | char_eur | char_iso | char_jis | char_usa}

DateTimeResults

select @@DateTimeResults

set DateTimeResults {datetime | datetime4 | char_eur | char_iso | char_jis | char_usa}

DecimalResults

select @@DecimalResults

set DecimalResults {autoconvert | char | int | real | float | money | money4 | bcd}

FloatResults

select @@FloatResults

set FloatResults {float | real | char}

GraphicResults

select @@GraphicResults

set GraphicResults {binary | char}

Int2Results

select @@Int2Results

set Int2Results {smallint | char}

Int4Results

select @@Int4Results

set Int4Results {int | char}

RealResults

select @@RealResults

set RealResults {float | real | char}

TimeResults

select @@TimeResults

set TimeResults {datetime | datetime4 | char_eur | char_iso | char_jis | char_usa}

Configuration Property

Global Variable and set Statement

CharConvertError

select @@CharConvertError

set CharConvertError {reject | truncate}

DateTimeConvertError

select @@DateTimeConvertError

set DateTimeConvertError {reject | null | default}

NumConvertError

select @@NumConvertError

set NumConvertError {reject | null | default}

Configuration Property

Global Variable and set Statement

BulkCommitCount

select @@BulkCommitCount

set BulkCommitCount integer

TransferBatch

select @@TransferBatch

set TransferBatch integer

TransferErrorCount

select @@TransferErrorCount

set TransferErrorCount integer

Global Variable and set statement

Description

select @@AllResults

set AllResults {autoconvert | char}

Returns group datatype conversions.

Sets group datatype conversions:

• autoconvert sets all datatype conversions to the default values.

• char sets all datatype conversions to CS_CHAR.

select @@CloseOnEndtran

set CloseOnEndtran {on | off}

Returns how cursors behave when a commit is executed.

Determines how cursors behave when a commit is executed:

• on (the default) causes all cursors to be closed.

• off causes cursors to remain open at their positions when the commit is executed.

select @@Connections

No set statement

Returns the current number of connections to this access service.

select @@DefaultedRowCount

No set statement

Returns the number of rows the access service returned with default values substituted for data conversion errors.

select @@Error

No set statement

Reflects the message number of each event. A successful event returns a 0 (zero).

select @@noexec

set noexec {on | off}

Returns whether metadata are returned for a select statement result set.

Determines whether metadata are returned for a select statement result set:

• on sets the access service to handle subsequent select statements such that no results rows are returned, but result set metadata are available.

• off (the default) returns the access service to the normal mode of returning result sets.

select @@RejectedRowCount

No set statement

Returns the number of rows rejected by the access service due to data conversion errors.

select @@RowCount

No set statement

Returns the number of rows affected by the last SQL statement processed.

select @@ServiceName

No set statement

Returns this access service name.

select @@spid

No set statement

Returns a unique positive integer identifier (server process ID) for the current client connection.

select @@TargetError

No set statement

Returns the message number of the last target database error.