Table A-1 shows all the configuration properties for ECDA Option for ODBC, which accesses DB2 UDB, Microsoft SQL Server, and ODBC-accessible data sources.
The property category represents the subsection heading in the access service library configuration file for ECDA Option for ODBC targets.
The far right column identifies the following:
GV = global variable, which allows an application to issue a select statement to query a global variable for the values of the property and view those values.
SS = set statement, which allows an application to change the values of the property—but only for the current connection.
None = the values of a configuration property cannot be accessed by either global variable or a set statement. You can use DirectConnect Manager to do so, or you can access the file directly.
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 |
[Service Library] {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 |
ODBCDriverManager |
ODBC Driver Manager library name |
[Service Library] {Client Interaction} |
None |
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 |
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 |
[Service Library] {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 |
TransferBatchSeparator |
integer |
{Transfer} |
GV and SS |
TransferErrorAction |
[noaction | rollback] |
{Transfer} |
GV and SS |
TransferErrorCount |
integer |
{Transfer} |
GV and SS |
TransferPacketSize |
integer |
{Transfer} |
GV and SS |
Version |
versionstring |
{Client Interaction} |
GV |
XNLChar |
integer |
{Datatype Conversion} |
GV and SS |
XNLVarChar |
integer |
{Datatype Conversion} |
GV and SS |
For detailed explanations of configuration properties, see Chapter 2, “Configuring the Access Service Library.”
