For detailed explanations of configuration properties, see Chapter 2, “Creating and Configuring DB2 Access Services.”
Table A-1 lists DB2 access service library and DB2 access service properties in alphabetical order. The property category represents the subsection heading in the service library configuration file.
Property name |
Property values |
Property category {subsection name} |
Global variable (GV) or set statement (SS) |
|---|---|---|---|
Allocate |
[ connect | request ] |
{Target Interaction} |
GV and SS |
APPCSecurity |
[ pgm | none | same ] |
{Target Interaction} |
none |
ApplicationValidationFile |
pathfilename |
{Client Interaction} |
none |
BinaryResults |
[ binary | char ] |
{Datatype Conversion} |
GV and SS |
CharConvertError |
[ reject | truncate ] |
{Data Conversion Errors} |
GV and SS |
ClientDecimalSeparator |
char |
{Client Interaction} |
GV and SS |
ClientIdleTimeout |
integer |
{Client Interaction} |
none |
ConnectionProtocol |
[ lu62 | tcpip ] |
{ACS Required} |
none |
ConnectionSpec1 |
char |
{ACS Required} |
none |
ConnectionSpec2 |
char |
{ACS Required} |
none |
ConnectionSpec3 |
char |
{ACS Required} |
none |
CSPCatalogQualifier |
qualifier |
{Catalog Stored Procedures} |
GV and SS |
CSPDBName |
dbname |
{Catalog Stored Procedures} |
GV and SS |
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 |
CSPQualByDBName |
[ 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 |
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 |
DefaultTime |
hh.mm.ss |
{Data Conversion Errors} |
none |
EnableAtStartup |
[ no | yes ] |
{Client Interaction} |
none |
FloatResults |
[ float | real | char ] |
{Datatype Conversion} |
GV and SS |
GatewayCompatible |
[ no | yes ] |
{Client Interaction} |
GV |
GraphicResults |
[ binary | char ] |
{Datatype Conversion} |
GV and SS |
Int2Results |
[ smallint | char ] |
{Datatype Conversion} |
GV and SS |
Int4Results |
[ int | char ] |
{Datatype Conversion} |
GV and SS |
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 |
PasswordRequired |
[ no | yes ] |
{Target Interaction} |
none |
QuotedStringDelimiter |
char |
{Target Interaction} |
none |
RealResults |
[ float | real | char ] |
{Datatype Conversion} |
GV and SS |
SendWarningMessages |
[ no | yes ] |
{Client Interaction} |
GV and SS |
ServiceDescription |
char |
{Client Interaction} |
GV |
SvclibDescription |
char |
{Client Interaction} |
GV |
SQLInformationFile |
filename |
{Catalog Stored Procedures} |
none |
SQLTransformation |
[ passthrough | sybase | tsql0 | tsql1 | tsql2 | db2 ] |
{Target Interaction} |
GV and SS |
StopCondition |
[ error | none | warning ] |
{Target Interaction} |
GV and SS |
StripBinaryZero |
[ no | yes ] |
{Client Interaction} |
GV and SS |
TargetDebug |
[ none | statistics | time | trace ] |
{Target Interaction} |
GV and SS |
TargetDecimalSeparator |
char (default is a period) |
{Target Interaction} |
GV |
TargetHasMixedData |
[ no | yes ] |
{Target Interaction} |
none |
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 |
TPName |
tpname |
{ACS Required} |
none |
TraceEvents |
[ no | yes ] |
{Tracing} |
none |
TraceHostCom |
[ 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 |
