Configuration templates

The following templates for DirectConnect targets show all of the DirectConnect configuration properties. Use these templates to set up your configuration file.

Configuration template for DirectConnect

In the following template, there are two required properties indicated with an asterisk (*), that have entries for DirectConnect for Microsoft SQL Server. For guidelines on configuring these properties, see “List of configuration property categories”.

[Service Library]
{ACS Required}
*ConnectionSpec1=dcmsss

{Catalog Stored Procedures}
CSPColumnODBCVersion=

CSPExclusions=
CSPIncludeAlias=
CSPIncludeSynonym=
CSPIncludeSystem=
CSPIncludeTable=
CSPIncludeView=
DatatypeInfo=

{Client Interaction}
ClientDecimalSeparator=
ClientIdleTimeout=
*EnableAtStartup=yes
MaxResultSize=
MaxRowsReturned=
MaxSvcConnections=
quoted_identifiers=
SendWarningMessages=
ServiceDescription=
StripBinaryZero=
SvclibDescription=
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=
LogSvclibStatistics=
LogTargetActivity=
LogTransferStatistics=
LogTransformedSQL=

{Target Interaction}
Allocate=
DelimitSQLRequests=
IsolationLevel=
QuotedStringDelimeter=
ReturnNativeError=
SQLOdbcCursors=
SQLTransformation=
StopCondition=
TargetDBMS=
TargetDecimalSeparator=

{Tracing}
TraceEvents=
TraceInterface=
TraceTarget=

{Transfer}
BulkCommitCount=
TransferBatch=
TransferErrorAction
TransferErrorCount=
TransferExpress=