A list of configuration properties for ECDA Option for ODBC, which accesses DB2 UDB, Microsoft SQL Server, and ODBC-accessible datasources.
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:
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 |
[no | yes] |
{Catalog Stored Procedures} |
GV and SS |
|
CSPIncludeView |
[no | yes] |
{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 |
[no | yes] |
{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 |