Configuration Property Quick Reference

This appendix contains a quick reference table for all configuration properties and a file template showing all possible configuration properties.

For detailed explanations of configuration properties, see Chapter 2, "Configuring the DirectConnect Access Service Library"

Quick Reference table

In the following table, the property category represents the subsection heading in the service library configuration file.

Configuration properties
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
DefaultClientCodeset	clientcodeset	{ACS Required}	GV and SS
DefaultDate	yyyy-mm-dd	{Data Conversion Errors}	none
DefaultNum	integer	{Data Conversion Errors}	none
DefaultTargetCodeset	targetcodeset	{ACS Required}	GV and SS
DefaultTime	hh.mm.ss	{Data Conversion Errors}	none
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
RealResults	[float \| real \| char]	{Datatype Conversion}	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
SQLInformationFile	filename	{Catalog Stored Procedures}	none
SQLTransformation	[passthrough \| sybase \| tsql0 \| tsql1 \| tsql2]	{Target Interaction}	GV and SS
StopCondition	[error \| none \| warning]	{Target Interaction}	GV and SS
SvclibDescription	char	{Client Interaction}	GV
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
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
TransferErrorCount	integer	{Transfer}	GV and SS
Version	versionstring	{Client Interaction}	GV

Configuration Template

The following template shows all possible DirectConnect Anywhere configuration properties. Use this template for setting up your own configuration file.

For guidelines on configuring any of these properties, see Chapter 2, "Configuring the DirectConnect Access Service Library"

[Service  Library]
 {ACS Required}
 ConnectionSpec1=
 DefaultClientCodeset=
 DefaultTargetCodeset=

{Catalog Stored Procedures}
 CSPExclusions=
 CSPIncludeAlias=
 CSPIncludeSynonym=
 CSPIncludeSystem=
 CSPIncludeTable=
 CSPIncludeView=
 DatatypeInfo=

{Client Interaction}
 ClientDecimalSeparator=
 ClientIdleTimeout=
 EnableAtStartup=
 MaxResultSize=
 MaxRowsReturned=
 MaxSvcConnections=
 SendWarningMessages=
 ServiceDescription=
 SvclibDescription=
 TextSize=
 TransactionMode=
 Version=

{Data Conversion Errors}
 CharConvertError=
 DateTimeConvertError=
 DefaultDate=
 DefaultNum=
 DefaultTime=
 NumConvertError=

{Datatype Conversion}
 BinaryResults=
 DateResults=
 DateTimeResults=
 DecimalResults=
 FloatResults=
 Int2Results=
 Int4results=
 RealResults=
 TimeResults=

{Logging}
 LogConnectionStatistics=
 LogReceivedSQL=
 LogRequestStatistics=
 LogServiceStatistics=
 LogSvclibStatistics=
 LogTargetActivity=
 LogTransferStatistics=
 LogTransformedSQL=

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

{Tracing}
 TraceEvents=
 TraceInterface=
 TraceTarget=

{Transfer}
 BulkCommitCount=
 TransferBatch=
 TransferErrorCount=


	Expand Search