Access Service User's Guide DirectConnect for AS/400

Property Name

Property Values

Property Category {Subsection Name}

Global Variable (GV) or set Statement (SS)

Allocate

[ connect | request ]

{Target Interaction}

GV and SS

APPCSecurity

[ pgm | none | same ]

{Target Interaction}

none

ApplicationValidationFile

pathfilename

{Client Interaction}

none

ASCIICodeset

char

{ACS Required}

none

BinaryResults

[ binary | char ]

{Datatype Conversion}

GV and SS

CharConvertError

[ reject | truncate ]

{Data Conversion Errors}

GV and SS

ClientDecimalSeparator

char

{Client Interaction}

GV and SS

ClientIdleTimeout

integer

{Client Interaction}

none

ConnectionProtocol

lu62

{ACS Required}

none

ConnectionSpec1

char

{ACS Required}

none

ConnectionSpec2

char

{ACS Required}

none

ConnectionSpec3

char

{ACS Required}

none

CSPCatalogQualifier

qualifier

{Catalog Stored Procedures}

GV and SS

CSPDBName

dbname

{Catalog Stored Procedures}

GV and SS

CSPIncludeSystem

[ no | yes ]

{Catalog Stored Procedures}

GV and SS

CSPIncludeTable

[ yes | no ]

{Catalog Stored Procedures}

GV and SS

CSPIncludeView

[ yes | no ]

{Catalog Stored Procedures}

GV and SS

CSPQualByDBName

[ no | yes ]

{Catalog Stored Procedures}

GV and SS

DatabaseName

databasename

{ACS Required}

none

DatatypeInfo

[ transact | target ]

{Catalog Stored Procedures}

GV and SS

DateResults

[ datetime | datetime4 | char_iso | char_usa | char_eur | char_jis ]

{Datatype Conversion}

GV and SS

DateTimeConvertError

[ reject | null | default ]

{Data Conversion Errors}

GV and SS

DateTimeResults

[ datetime | datetime4 | char_iso | char_usa | char_eur | char_jis ]

{Datatype Conversion}

GV and SS

DecimalResults

[ autoconvert | int | float | real | char | money | money4 | bcd ]

{Datatype Conversion}

GV and SS

DefaultClientCodeset

clientcodeset

{ACS Required}

GV and SS

DefaultDate

yyyy-mm-dd

{Data Conversion Errors}

none

DefaultNum

integer

{Data Conversion Errors}

none

DefaultTargetCodeset

targetcodeset

{ACS Required}

GV

DefaultTime

hh.mm.ss

{Data Conversion Errors}

none

EBCDICCodeset

char

{ACS Required}

none

EnableAtStartup

[ no | yes ]

{Client Interaction}

none

FloatResults

[ float | real | char ]

{Datatype Conversion}

GV and SS

GatewayCompatible

[ no | yes ]

{Client Interaction}

GV

GraphicResults

[ binary | char ]

{Datatype Conversion}

GV and SS

Int2Results

[ smallint | char ]

{Datatype Conversion}

GV and SS

Int4Results

[ int | char ]

{Datatype Conversion}

GV and SS

IsolationLevel

[ cs | ur | no ]

{Target Interaction}

none

LogConnectionStatistics

[ no | yes ]

{Logging}

none

LogReceivedSQL

[ no | yes ]

{Logging}

none

LogRequestStatistics

[ no | yes ]

{Logging}

none

LogServiceStatistics

integer

{Logging}

none

LogSvclibStatistics

integer

{Logging}

none

LogTargetActivity

[ no | yes ]

{Logging}

none

LogTransferStatistics

[ no | yes ]

{Logging}

none

LogTransformedSQL

[ no | yes ]

{Logging}

none

MaxResultSize

integer

{Client Interaction}

GV and SS

MaxRowsReturned

integer

{Client Interaction}

GV and SS

MaxSvcConnections

integer

{Client Interaction}

GV

NumConvertError

[ reject | null | default ]

{Data Conversion Errors}

GV and SS

PasswordRequired

[ no | yes ]

{Target Interaction}

none

QuotedStringDelimiter

char

{Target Interaction}

none

QCCSIDRemap

[ ccsid| alt_ccsid ]

(Target Interaction)

GV and SS

RealResults

[ float | real | char ]

{Datatype Conversion}

GV and SS

SendWarningMessages

[ no | yes ]

{Client Interaction}

GV and SS

ServiceDescription

char

{Client Interaction}

GV

SvclibDescription

char

{Client Interaction}

GV

SQLInformationFile

filename

{Catalog Stored Procedures}

none

SQLTransformation

[ passthrough | sybase | tsql0 | tsql1 | tsql2 ]

{Target Interaction}

GV and SS

StopCondition

[ error | none | warning ]

{Target Interaction}

GV and SS

TargetDecimalSeparator

char (default is a period)

{Target Interaction}

GV

TextSize

integer

{Client Interaction}

GV and SS

TimeResults

[ datetime | datetime4 | char_iso | char_usa | char_eur | char_jis ]

{Datatype Conversion}

GV and SS

TPName

tpname

{ACS Required}

none

TraceDRDATrans

[ no | yes ]

{Tracing}

none

TraceEvents

[ no | yes ]

{Tracing}

none

TraceHostCom

[ no | yes ]

{Tracing}

none

TraceInterface

[ no | yes ]

{Tracing}

none

TraceTarget

[ no | yes ]

{Tracing}

none

TransactionMode

[ short | long ]

{Client Interaction}

GV and SS

TransferBatch

integer

{Transfer}

GV and SS

TransferErrorCount

integer

{Transfer}

GV and SS

Version

versionstring

{Client Interaction}

GV