The following Quick Reference table shows all the DirectConnect configuration properties for:
DirectConnect DB2 UDB
DirectConnect for Informix
DirectConnect for Microsoft SQL Server
DirectConnect for ODBC
In the following table, the property category represents the subsection heading in the access service library configuration file for DirectConnect targets.
For detailed explanations of configuration properties, see Chapter 2, “Configuring the Access Service Library 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 |
