| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Access Service User's Guide DirectConnect |
![[-]](/dwicons/i_colpse.gif)
| Appendix B Quick Reference |
Chapter 16
This appendix contains quick reference tables for the following topics:
For detailed explanations of configuration properties, see Chapter 2, "Configuring the DirectConnect Access Service Library"
The following table lists access service library and 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 |
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 |
This section contains code set tables for two configuration properties:
DefaultClientCodeset
DefaultTargetCodeset
For current information on certified code sets, check the Sybase Web site or contact your local Sybase office. To request certification for a new code set, contact your local Sybase office.
The following table shows all values for the DefaultClientCodeset configuration property.
Code Set Identifier | Description | Certified |
9 | EUC-CNS encoding | |
10 | EUC-GB encoding | |
11 | Microsoft CP932 | |
12 | ISO 8859-2 Latin-2 Eastern Europe | |
13 | ISO-885905 Latin/Cyrillic | |
14 | ISO 8859-6 Latin/Arabic | |
15 | ISO 8859-7 Latin/Greek | |
16 | ISO 8859-8 Latin/Hebrew | |
17 | ISO 8859-9 Latin-5 Turkish | |
26 | Macintosh Cyrillic | |
27 | Macintosh Eastern Europe | |
28 | Macintosh Greek | |
29 | Macintosh Turkish | |
30 | HP Greek | |
31 | HP Turkish | |
32 | KOI8 - Cyrillic | |
33 | Thai Standard | |
420 | Arabic Bilingual | |
437 | U. S. code page | yes |
819 | ISO 8859-1 Latin | yes |
850 | European code page | yes |
852 | PC Eastern European | |
855 | PC Cyrillic | |
857 | PC Turkish | |
860 | PC Portuguese | |
861 | Icelandic | |
863 | PC Canadian French code page | yes |
864 | PC Arabic | |
866 | PC Russian | |
869 | PC Greek | |
874 | Microsoft Thai SB code page | |
932 | Japanese IBM J-DBCS | yes |
949 | PC MS Korean | |
950 | PC MS Traditional Chinese | |
954 | EUCJIS | yes |
1250 | MS Windows East Europe | |
1251 | MS Windows Cyrillic | |
1252 | MS Windows US | |
1253 | MS Windows Greek | |
1254 | MS Windows Turkish | |
1255 | MS Windows Hebrew | |
1256 | MS Windows Arabic | |
deckanji | Digital UNIX JIS encoding | yes |
eucjis | EUC-JIS encoding | yes |
mac | Standard Macintosh Roman | yes |
roman8 | HP Roman8 | yes |
sjis | Shift-JIS proper | yes |
The following table shows all values that the DefaultTargetCodeset configuration property can use.
Code Set Identifier | Description (alternate identifier) | Certified |
37 | IBM EBCDIC code page | yes |
273 | IBM EBCDIC Germany/Austria code page | yes |
277 | IBM EBCDIC Denmark/Norway code page | yes |
278 | IBM EBCDIC Finland/Sweden code page | yes |
280 | IBM EBCDIC Italian code | yes |
284 | IBM EBCDIC Spain/Latin America code page | yes |
285 | IBM EBCDIC U.K. code page | |
297 | IBM EBCDIC France code page | |
420 | Arabic Bilingual | |
500 | Western Europe code page | yes |
870 | Eastern Europe | |
874 | Microsoft Thai SB code page | |
875 | Greek code page | |
933- 833 - 834 | MBCS Korean - SBCS - DBCS | |
935 - 836 - 837 | MBCS Simplified Chinese - SBCS - DBCS | |
937 - 37 - 835 | MBCS Traditional Chinese - SBCS - DBCS | |
1047 | MVS Open Edition | |
5026 - 290 - 4396 | MBCS IBM Kanji (Katakana) - SBCS - DBCS | yes |
5035 - 1027 - 4396 | MBCS IBM Kanji (Latin) - SBCS - DBCS | yes |
cxgwebc | MDI Gateway-compatible | yes |
cxpsebc | PeopleSoft Custom |
|
|