Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Querying global variables [Table of Contents] Querying and setting processing values

Access Service User's Guide DirectConnect for AS/400

[-] Chapter 3 Querying and setting operating values
[-] Querying and setting properties

Querying and setting properties

Some configuration property values can be queried or set using global variables and set statements. These properties appear grouped by category in the following sections:

Configuration properties, global variables, and set statements are not case sensitive.

For explanations of configuration properties, see Chapter 2, "Configuring the DirectConnect Access Service Library"

Access service (ACS) required properties

The following table shows access service required properties and associated global variables and set statements.

Access service required properties

Configuration Property

Global Variable and set Statement

DefaultClientCodeset

select @@DefaultClientCodeset

set DefaultClientCodeset codeset

DefaultTargetCodeset

select @@DefaultTargetCodeset

No set statement

Target interaction properties

The following table shows target interaction properties and associated global variables and set statements.

Target interaction properties

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

Catalog stored procedure properties

The following table shows catalog stored procedure (CSP) properties and associated global variables and set statements.

Catalog Stored Procedures properties

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}

Client interaction properties

The following table shows client interaction properties and associated global variables and set statements.

Client interaction properties

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 .

Datatype conversion properties

The following table shows datatype conversion properties and associated global variables and set statements.

Datatype conversion properties

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}

Data conversion error properties

The following table shows data conversion error properties and associated global variables and set statements.

Data conversion errors properties

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}

Transfer properties

The following table shows transfer properties and associated global variables and set statements.

Transfer properties

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

Querying global variables [Table of Contents] Querying and setting processing values