The following templates for ECDA targets show all of the configuration properties, organized as they appear in the configuration file layout. Use these templates to set up your configuration file.
In this template, two required properties have entries
for ODBC data targets: ConnectionSpec1 and EnableAtStartup. For
guidelines on configuring these properties, see “Configuration property categories”.
[Service Library]
{Client Interaction}
ODBCDriverManager=
SvclibDescription=
{Logging}
LogSvcLibStatistics=
[Service Name]
{ACS Required}
ConnectionSpec1=ODBCDataSource
{Catalog Stored Procedures}
CSPColumnODBCVersion=
CSPExclusions= CSPIncludeAlias= CSPIncludeSynonym= CSPIncludeSystem= CSPIncludeTable= CSPIncludeView= DatatypeInfo=
{Client Interaction}
ClientDecimalSeparator=
ClientIdleTimeout=
EnableAtStartup=
MaxResultSize=
MaxRowsReturned=
MaxSvcConnections=
quoted_identifiers=
SendWarningMessages=
ServiceDescription=
StripBinaryZero=
StripString=TextSize=
TextSize=
TransactionMode=
Version=
{Data Conversion Errors}
CharConvertError=
DateTimeConvertError=
DefaultDate=
DefaultNum=
DefaultTime=
NumConvertError=
{Datatype Conversion}
BinaryResults=
DateResults=
DateTimeResults=
DecimalResults=
FloatResults=
Int2Results=
Int4results=
RealResults=
TimeResults=
TinyIntResults=
XNLChar=
XNLVarChar=
{Logging}
LogConnectionStatistics=
LogReceivedSQL=
LogRequestStatistics=
LogServiceStatistics=
LogTargetActivity=
LogTransferStatistics=
LogTransformedSQL=
{Target Interaction}
Allocate=
DelimitSQLRequests=
DisableROLock=
IsolationLevel=
QuotedStringDelimeter=
ReturnNativeError=
SQLOdbcCursors=
SQLTransformation=
StopCondition=
TargetDBMS=
TargetDecimalSeparator=
{Tracing}
TraceEvents=
TraceInterface=
TraceTarget=
{Transfer}
BulkCommitCount=
TransferBatch=
TransferBatchSeparator=
TransferErrorAction=
TransferErrorCount=
TransferExpress=
TransferPacketSize=
