Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 3 Tools : NLS

NLS
Enables the database administrator to set code page values in translation tables. (E)
Invocation
Do one of the following:
Usage Notes
You must execute NLS from a level-7 user ID.
Code Page Lookup
When determining if translation is to be performed for external DBMS data, TIBCO Object Service Broker looks at code pages in the following order:
1.
2.
3.
4.
NLS Screen
On entering the NLS tool, the following screen appears:

 
National Language Support Manager
TDS and peer to peer Code Page Settings
Locale.Codepage
SELF ENGL.IBM-037
REMOTE ENGL.IBM-037
Service Gateway for Files Code Page Settings (By Server ID)
Server ID Locale.Codepage
* NO CODEPAGE *
External DBMS Code Page Settings (By Table Type)
Type Locale.Codepage
* NO CODEPAGE *
External DBMS Code Page Settings (By Server ID)
Server ID Locale.Codepage
* NO CODEPAGE *
External DBMS Code Page Settings (By Table Name)
Table Name Type Locale.Codepage
#ACT1 DAT DVDFFGF
@IDMS_ELEMENTS * SECURITYFAIL *
PFKEYS: 3=EXIT 5=EDIT 6=ADD 12=EXIT
Place cursor on appropriate entry then PF5 to edit or PF6 to add

 
There are five areas to set code pages, as shown in the following sections.
TDS and peer to peer Code Page Settings
In this area, you set the SELF and REMOTE code pages. SELF is the code page for user character data stored in user TDS tables in the local Data Object Broker and REMOTE is the code page for character data in peer-to-peer communication.
Service Gateway for Files Code Page Settings (By Server ID)
All accesses for a specific Server ID are translated. For example, you could have two different remote instances of the Service Gateway for Files with different code page settings.
External DBMS Code Page Settings
In the next three areas, you specify the code pages of your external DBMSs. You can do this at three levels of detail.
 
All accesses for a specific Server ID are translated. For example, you could have two different DB2 gateways with different code page settings.
Pressing PF5 on the appropriate section brings up a Table Editor window where you can edit the table. Here are some examples:
Service Gateway for Files

 
EDITING TABLE : @SERVERCONFIG(_FG)
COMMAND ==>
SCROLL: P
NAME TYPE SYNTAX LENGTH DECIMAL VALUE MODIFY
_ ---------------- - - ------ ------ --------------------------------- -
_ SERVERLS S V 32 SVEN.IBM-278 N

 
By Table Type

 
EDITING TABLE : @SERVERCONFIG(_NT)
COMMAND ==>
NAME TYPE SYNTAX LENGTH DECIMAL VALUE MODIFY
_ ---------------- - - ------ ------ --------------------------------- -
_ DB2 S V 32 0 ENGL.IBM-500 N
_ IMS S V 32 0 ENGL.IBM-500 N

 
By Server ID

 
EDITING TABLE : @SERVERCONFIG(_NS)
COMMAND ==>
NAME TYPE SYNTAX LENGTH DECIMAL VALUE MODIFY
_ ---------------- - - ------ ------ --------------------------------- -
_ DB2ITAL S V 32 ENGL.IBM-280 N
_ DB2ESPA S V 32 ENGL.IBM-284 N

 
By Table Name

 
EDITING TABLE : @SERVERPARMS(DB2CUST)
COMMAND ==>
NUMBER NAME TYPE SYNTAX LENGTH DECIMAL DEFAULT USAGE SCOPE MUSTINCLDEFN
_ ---------- --------- - - ------ ------ ------------- - - -
_ 1 SERVERID S C 8 0 DEFAULT C Y Y
_ 2 SERVERTYPE S C 3 0 T Y Y
_ 3 CODEPAGE S V 32 0 NORS.IBM-277 Y Y N

 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved