The following Quick Reference table shows all the DirectConnect configuration
properties for:
In the following table, the property category represents the
subsection heading in the access service library configuration file
for DirectConnect targets.
Table A-1: Configuration properties for
DirectConnect
Property
name
|
Property
values
|
Property
category
{subsection name}
|
Global variable (GV) or set statement (SS)
|
Allocate
|
[connect | request]
|
{Target
Interaction}
|
GV and SS
|
BinaryResults
|
[binary | char]
|
{Datatype
Conversion}
|
GV and SS
|
BulkCommitCount
|
integer
|
{Transfer}
|
none
|
CharConvertError
|
[reject | truncate]
|
{Data
Conversion Errors}
|
GV and SS
|
ClientDecimalSeparator
|
char
|
{Client
Interaction}
|
GV and SS
|
ClientIdleTimeout
|
integer
|
{Client
Interaction}
|
none
|
ConnectionSpec1
|
char
|
{ACS
Required}
|
none
|
CSPExclusions
|
[none | user | nonauth | nonauthpublic]
|
{Catalog
Stored Procedures}
|
GV and SS
|
CSPIncludeAlias
|
[no | yes]
|
{Catalog
Stored Procedures}
|
GV and SS
|
CSPIncludeSynonym
|
[no | yes]
|
{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
|
DatatypeInfo
|
[transact | target]
|
{Catalog
Stored Procedures}
|
GV and SS
|
DateResults
|
[datetime | datetime4 | char_iso | char_usa |
char_eur | char_jis | char_odbc]
|
{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 | char_odbc]
|
{Datatype
Conversion}
|
GV and SS
|
DecimalResults
|
[autoconvert | int | float | real | char | money | money4 | bcd]
|
{Datatype
Conversion}
|
GV and SS
|
DefaultDate
|
yyyy-mm-dd
|
{Data
Conversion Errors}
|
none
|
DefaultNum
|
integer
|
{Data
Conversion Errors}
|
none
|
DefaultTime
|
hh.mm.ss
|
{Data
Conversion Errors}
|
none
|
DelimitSqlRequests
|
[no | yes]
|
{Target Interaction}
|
GV and SS
|
EnableAtStartup
|
[no | yes]
|
{Client
Interaction}
|
none
|
FloatResults
|
[float | real | char]
|
{Datatype
Conversion}
|
GV and SS
|
Int2Results
|
[smallint | char]
|
{Datatype
Conversion}
|
GV and SS
|
Int4Results
|
[int | char]
|
{Datatype
Conversion}
|
GV and SS
|
IsolationLevel
|
[ur | cr | rr | sr | vr | no]
|
{Target
Interaction}
|
GV
|
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
|
quoted_identifier
|
[on | off]
|
{Client
Interaction}
|
GV and SS
|
QuotedStringDelimiter
|
char
|
{Target Interaction}
|
GV and SS
|
RealResults
|
[float | real | char]
|
{Datatype
Conversion}
|
GV and SS
|
ReturnNativeError
|
[no | yes]
|
{Target Interaction}
|
GV and SS
|
SendWarningMessages
|
[no | yes]
|
{Client
Interaction}
|
GV and SS
|
ServiceDescription
|
char
|
{Client
Interaction}
|
GV
|
SQLOdbcCursors
|
[if_needed | odbc | driver | default]
|
{Target
Interaction}
|
SS
|
SQLTransformation
|
[passthrough | sybase |
tsql0 | tsql1 | tsql2]
|
{Target
Interaction}
|
GV and SS
|
StripBinaryZero
|
[yes | no]
|
{Client
Interaction}
|
GV and SS
|
StopCondition
|
[error | none | warning]
|
{Target
Interaction}
|
GV and SS
|
SvclibDescription
|
char
|
{Client
Interaction}
|
GV
|
TargetDBMS
|
[ notused | UDBLAN | UDBOS390 | UDBAS400 ]
|
{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 | char_odbc ]
|
{Datatype
Conversion}
|
GV and SS
|
TinyIntResults
|
[smallint | tinyint ]
|
{Datatype
Conversion}
|
GV and SS
|
TraceEvents
|
[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
|
TransferErrorAction
|
[noaction | rollback]
|
{Transfer}
|
GV and SS
|
TransferErrorCount
|
integer
|
{Transfer}
|
GV and SS
|
Version
|
versionstring
|
{Client
Interaction}
|
GV
|
XNLChar
|
integer
|
{Datatype
Conversion}
|
GV and SS
|
XNLVarChar
|
integer
|
{Datatype
Conversion}
|
GV and SS
|