| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Access Service User's Guide DirectConnect for AS/400 |
![[-]](/dwicons/i_colpse.gif)
| Chapter 2 Configuring the DirectConnect Access Service Library |
|
| Access service required properties |
These properties require site-specific values. Be sure to supply these values for your installation.
The subsection heading for these properties must appear in the service library configuration file as:
{ACS Required}Specifies the ASCII code set to use for conversions to and from ASCII and EBCDIC.
ASCIICodeset=char
1-255 characters
No default
char specifies the ASCII code set.
Unless you use a different ASCII code set to handle special characters, the ASCIICodeset value is the same as the DefaultClientCodeset value. See "DefaultClientCodeset" .
Specifies the protocol the access service uses to connect to the target database.
ConnectionProtocol=lu62
lu62
lu62 specifies that the access service uses LU 6.2 communications to connect to the target database.
LU6.2 is the only protocol the access service uses to connect to the AS/400. Do not change the value for this property.
Specifies the platform-specific LU 6.2 connection information for LU 6.2 communications.
ConnectionSpec1=char
1-255 characters
No default
This value is platform-dependent:
Windows NT: Local LU Alias
Solaris: Unique Session Name
HP: Local LU Alias
AIX: Side information profile name
The communications protocol determines the maximum acceptable length for this property value.
Specifies the platform-specific LU 6.2 connection information.
ConnectionSpec2=char
1-255 characters
No default
The value is platform-dependent:
Windows NT: Remote LU Alias
Solaris: Name of the machine running the SunLink SNA Gateway, or localhost (if running on the same machine as DirectConnect)
HP: Remote LU Alias
AIX: Not used, but must not be blank
The communications protocol determines the maximum acceptable length for this property value.
Specifies the SNA mode name for LU 6.2 communications.
ConnectionSpec3=char
1-255 characters
No default
char is the SNA mode name for LU 6.2 communications.
The communications protocol determines the maximum acceptable length for this property value.
The AS/400 database name.
DatabaseName=databasename
0-255 characters
No default
databasename is the name of the AS/400 database.
To create the AS/400 database name, use the add relational database directory entry (ADDRDBDIRE) command, setting the remote location to *LOCAL. To query the AS/400 database name, use the WRKRDBDIRE command. For more information, see the appropriate AS/400 documentation.
Specifies the Coded Character Set Identifier (CCSID) or code set the client application uses when sending information to the access service.
DefaultClientCodeset=clientcodeset
1-255 characters
OpenServerDefault
To operate correctly, the access service requires a DefaultClientCodeset value that accurately reflects the code set of the client application.
Enter one of the following as the DefaultClientCodeset value:
The client application code set identifier.
The default setting, OpenServerDefault, which specifies that the access service uses the code set value passed in the login record. This allows each individual Open Client DB-Library or CT-Library application to specify its code set in the login record.
If the DefaultClientCodeset property value is OpenServerDefault and the client application does not specify a valid code set in the login record, Open Server populates the login record with Open Server defaults specified in the $SYBASE\locales\locales.dat file.
For a list of DefaultClientCodeset values, see Table B-11 .
When data passes from the client application to the target database, the access service converts the data from the DefaultClientCodeset to the DefaultTargetCodeset. (See "DefaultTargetCodeset" .)
If the DefaultClientCodeset value is a specific code set value (for example, 850, the code set for ASCII Latin), that code set is used for all client applications whether or not those applications specify a code set value in their login records.
The access service obtains the client application language from one of the following:
The login record
The locales.dat file, if the client application does not explicitly set the language
The server DefaultServerLanguage configuration property value
For information about the DefaultServerLanguage property, see the DirectConnect Server Administration Guide.
Specifies the target CCSID or code set the access service uses to convert characters when it sends data to the target database.
DefaultTargetCodeset=targetcodeset
1-255 characters
No default
The DefaultTargetCodeset value should match the effective CCSID of AS/400 users, defined by the QCCSID system value, unless the CCSID of a specific user profile overrides it.
For information about CCSIDs, see the AS/400 DB2/400 SQL Reference and the IBM National Language Design Guide, Vol. 2.
When data passes from the target database to the client application, the access service converts the data from the DefaultTargetCodeset to the DefaultClientCodeset. (See "DefaultClientCodeset" .)
The DefaultTargetCodeset property enables the access service to support single-byte, double-byte, or mixed-byte language machines.
For single-byte language machines, you specify the single-byte CCSID as the only argument. Use the IBM CCSID number, not the code page or character set number. The CCSID value is the CCSID defined by the AS/400 system value, QCCSID.
For example, if the QCCSID value is 65535, specify the language CCSID as the targetcodeset. Look at the AS/400 system value, QCHRID, to determine the CCSID to use for the targetcodeset.
For mixed-byte language machines, specify three CCSIDs separated by commas for the targetcodeset:
The first CCSID is the mixed-byte CCSID.
The second CCSID is the associated single-byte CCSID.
The third CCSID is the associated double-byte CCSID.
Use the QCCSID system values to determine the CCSIDs to use for the targetcodeset. If the QCCSID is 65535, use the QCHRID system value for the targetcodeset value.
To ensure that the access service returns data inserted into a table in the proper code set, use the same code set for both the insert and select operations. For example, if you insert an exclamation point character ("!", ASCII 0x21) where the ASCII to EBCDIC conversion is based on code page 37, this byte is converted to 0x5A for storage on the target database. If you later select this data using code page 500 as your target code set (DefaultTargetCodeset value is 500), the 0x5A is converted to a right square bracket ("]", ASCII 0x5D). Therefore, always select data in the same code set in which it was inserted.
For a list of DefaultTargetCodeset values, see Table B-12 .
For single-byte language machines:
If the QCCSID is 65535 and the machine is configured with French as the primary language (QCHRID=297), use the French CCSID of 297 as the targetcodeset:
DefaultTargetCodeset=297
If the QCCSID is 65535 and the machine is configured with U.S. English as the primary language (QCHRID=37), use the U.S. English CCSID of 37 as the targetcodeset:
DefaultTargetCodeset=37
For mixed-byte language machines:
If the QCCSID system value is 65535 and the machine is configured with Katakana as the primary language, use the following three CCSIDs separated by commas as the targetcodeset:
DefaultTargetCodeset=5026, 290, 4396
where:
5026 is the mixed-byte Katakana CCSID.
290 is the associated single-byte CCSID.
4396 is the associated double-byte CCSID.
For English/Japanese machines, use the following CCSIDs for the targetcodeset:
DefaultTargetCodeset=5035, 1027, 4396
where:
5035 is the mixed-byte Japanese-English CCSID.
1027 is the associated single-byte CCSID.
4396 is the associated double-byte CCSID.
Specifies the EBCDIC code set to use for conversions to and from ASCII and EBCDIC.
EBCDICCodeset=char
1-255 characters
No default
char specifies the EBCDIC code set.
Use CCSID 500 for the EBCDIC code set value unless your client application requires a different EBCDIC code set to handle special characters.
The transaction program name of the DRDA Application Server on the AS/400.
TPName=\x7F6DB
1-16 characters
\x7F6DB
\x7F6DB is the transaction program name of the DRDA Application Server on the AS/400.
Warning!
Do not change the default value of this property.
|
|