Access Service User's Guide DirectConnect for AS/400

MDI Catabase Gateway Global set statement

Corresponding Access Service Global Variable and set Statement

SELECT @@ALLOCATE

SET ALLOCATE {Connect | REQUEST}

select @@Allocate

set Allocate {connect | request}

SELECT @@BULK_COMMIT_COUNT

SET BULK_COMMIT_COUNT number

select @@BulkCommitCount

set BulkCommitCount integer

SELECT @@ConnectIONS

No set statement

select @@Connections

No set statement.

No global variable

SET CONVERT ALL {STD | CHAR | COBOL | IXF}

select @@AllResults

set AllResults {autoconvert | char}

STD = autoconvert (default) The access service does not support SET CONVERT ALL {COBOL | IXF}

SELECT @@CONVERT_SMALLINT

SET CONVERT SMALLINT [=] {STD |CHAR}

select @@Int2Results

set Int2Results {smallint | char}

STD = smallint (default)

SELECT @@CONVERT_INTEGER

SET CONVERT INTEGER [=] {STD | CHAR}

select @@Int4Results

set Int4Results {int | char}

STD = int (default)

SELECT @@CONVERT_CHAR

SET CONVERT CHAR [=] {STD | CHAR}

Has no effect in the access service.

SELECT @@CONVERT_VARCHAR

SET CONVERT VARCHAR [=] {STD | CHAR}

Has no effect in the access service

SELECT @@CONVERT_LVARCHAR

SET CONVERT LVARCHAR [=] {STD | CHAR}

Has no effect in the access service.

SELECT @@CONVERT_FLOAT

SET CONVERT FLOAT [=] {STD | CHAR | FLOAT | REAL}

select @@FloatResults

set FloatResults {float | char | real}

STD = float (default)

SELECT @@CONVERT_DECIMAL

SET CONVERT DECIMAL [=] {STD | CHAR | FLOAT | MONEY | BCD | REAL | SMALLMONEY}

select @@DecimalResults

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

STD = autoconvert (default) SMALLMONEY = money4

SELECT @@CONVERT_DATE

SET CONVERT DATE [=] {STD | ISO | USA | EUR | SMALLDATETIME}

select @@DateResults

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

STD = datetime (default) ISO = char_iso USA = char_usa EUR = char_eur SMALLDATETIME = datetime4

SELECT @@CONVERT_TIME

SET CONVERT TIME [=] {STD | ISO | USA | EUR | SMALLDATETIME}

select @@TimeResults

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

STD = datetime (default) ISO = char_iso USA = char_usa EUR = char_eur SMALLDATETIME = datetime4

SELECT @@CONVERT_TIMESTAMP

SET CONVERT TIMESTAMP [=] {STD | CHAR | SMALLDATETIME}

select @@DateTimeResults

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

STD = datetime (default) CHAR = char_iso SMALLDATETIME = datetime4

SELECT @@CSP_CATQUALIFIER

SET CSP_CATQUALIFIER qualifier

select @@CSPCatalogQualifier

set CSPCatalogQualfier qualifier

SELECT @@CSP_CATQUALIFIER_SET

No set statement

No global variable. Always returns YES.

SELECT @@CSP_INCLUDESYSTEM

SET CSP_INCLUDESYSTEM {NO | YES}

select @@CSPIncludeSystem

set CSPIncludeSystem {no | yes}

SELECT @@CSP_INCLUDETABLE

SET CSP_INCLUDETABLE {NO | YES}

select @@CSPIncludeTable

set CSPIncludeTable {no | yes}

SELECT @@CSP_INCLUDEVIEW

SET CSP_INCLUDEVIEW {NO | YES}

select @@CSPIncludeView

set CSPIncludeView {no | yes}

SELECT @@CSP_INCLUDE_SET

No set statement

No global variable. Always returns YES.

SELECT @@DECIMAL_SEP_IS_COMMA

No set statement

select @@ClientDecimalSeparator

SELECT @@DEFAULTED_ROWCOUNT

No set statement

select @@DefaultedRowCount

SELECT @@ERROR

No set statement

select @@Error

SELECT @@LONG_TRANS

SET LONG_TRANS {NO | YES}

select @@TransactionMode

Specifies whether the TransactionMode property is set to long. YES sets the property to long.

The access service set statement is: set TransactionMode {long | short}

SELECT @@MAX_CONNECTIONS

No set statement

select @@MaxSvcConnections

SELECT @@PREVIEW_COUNT

SET ROWCOUNT number

select @@MaxRowsReturned

set MaxRowsReturned integer

SELECT @@REJECTED_ROWCOUNT

No set statement

select @@RejectedRowCount

SELECT @@RMT_ERROR

No set statement

select @@TargetError

SELECT @@RESULT_SIZE

SET RESULTSIZE number

select @@MaxResultSize

set MaxResultSize integer

SELECT @@ROWCOUNT

No set statement

select @@Rowcount

SELECT @@STOP_CONDITION

SET STOP_CONDITION {ERROR | WARNING | NONE}

select @@StopCondition

set StopCondition {error | warning | none}

SELECT @@TEXTSIZE

SET TEXTSIZE number

select @@TextSize

set TextSize number

SELECT @@TRAN_SUPPORTED

Always returns PROG

SELECT @@TRANSFER_BATCH

SET TRANSFER_BATCH number

select @@TransferBatch

set TransferBatch integer

SELECT @@TRANSFER_ERROR_COUNT

SET TRANSFER_ERROR_COUNT number

select @@TransferErrorCount

set TransferErrorCount integer

SELECT @@TRANSFORM

SET TRANSFORM {TSQL0 | TSQL1 | TSQL2}

select @@SQLTransformation

set SQLTransformation {tsql0 | tsql1 | tsql2 | passthrough | sybase}

The access service maps tsql0 to access service passthrough mode. The access service supports tsql1 and tsql2 modes but does not map these modes to any access service mode.

SELECT @@VERBOSE

SET VERBOSE {NO | YES}

select @@SendWarningMessages

set SendWarningMessages {no | yes}

The access service SendWarningMessages global variable and set statement are not an exact match with the MDI Database Gateway VERBOSE global variable and set statement.

SELECT @@VERSION

No set statement

select @@version