For detailed explanations of configuration properties, see Chapter 2, “Creating and Configuring DB2 Access Services.”
The following table 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 |
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
