Code Tables (CODE)

Some operating systems and applications use special character sets. When the Automation Engine exchanges data with them, these character sets must be converted before they write data in the Automation Engine database. For this purpose you define Code Table objects.

This topic includes the following:

Overview

Code Table objects define a complete character set and are used for the following:

The Automation Engine manages its communication using the UC_CODE code table for the data traffic both between itself and the Agents and between Agents as depicted in the graphic below:

Graphic explaining the relationship between Code Tables, Agents and Communicaton Processes

Your administrator can assign a default code table to an Agent by defining the UC_HOST_CODE parameter in the [VARIABLES] section of the Agent's INI file. When the Agent logs on to the Automation Engine, the Automation Engine stores the Agent's Code Table names. Then it reads the code table from the system client 0 and transfers it to the Agent, which applies it to all jobs and file transfers that require character conversion.

Default Code Tables

Both the UC_CODE code table and the Agent code tables for operating systems and applications are supplied in Client 0 and they contain default character sets for all supported target systems.

Code Table Target System Character Set
ASCII_850

MS DOS

Includes German umlauts

BS2000_DEUTSCH

BS2000

Includes German umlauts

BS2000_EDF041

BS2000 In accordance with EDF041
BS2000_INTERNATIONAL BS2000

Alphanumeric with special characters

CODE  

Template for new code tables to be created

EBCDIC_00237   USA
EBCDIC_00037 OS/400 Germany and Austria
EBCDIC_00500   International
EBCDIC_01141  

Germany and Austria, with € symbol

IBM_3270_DEUTSCH

 

Includes German umlauts

IBM_3270_INTERNATIONAL z/OS International
UC_CODE

NSK

Oracle Applications

PeopleSoft

SAP

UNIX

VMS

Windows

Basic character set used by AE

Code Tables Usage and Job Execution

If no particular code table has been specified for a job, the Agent's default one is applied. This means that the Automation Engine sends the job data (JCL) using UC_CODE; the Agent converts it (if necessary) as required by the target system's character set. For this purpose, it uses the default Code Table sent to it by the Automation Engine during the login. After the job has been executed, the report that was generated is converted again using the character set as defined in UC_CODE and sent to the Automation Engine.

If a job does not use the default Code Table - but instead, for example, an ASCII character set for DOS outputs in Windows - this Code Table is first sent to the Agent. The Automation Engine searches for it in the numbered non-system client and, if it doesn't find it, the Code Table of client 0 is used. However, this is valid only temporarily and exclusively for this particular job's JCL and report.

Code Tables Usage and File Transfer

If no particular code table has been specified for a file transfer, the Agent's default ones are applied. The agent converts the source file to UC_CODE if required, and sends it to the partner Agent, which in turn converts it from UC_CODE to its particular character set using its default Code Table.

For file transfers, code tables can be specified explicitly for the sending and/or receiving Agent. This is essential when the contents of the file to be transferred do not comply with the default Code Tables of the Agents involved in the transaction. The Automation Engine sends the required Code Table to the Agent so that it can convert the contents of the file correctly. However, this is valid only temporarily and exclusively for the affected file transfer. Subsequent file transfers and/or jobs are not affected.

Adding a Code Table

Sometimes you may need a code table that differs from the default ones. The easiest way is to duplicate an existing one having the most similar character set of Client 0 and adapt it accordingly.

Code tables that have the same name may exist in different Clients, however, the code table names of the system Client 0 must be unique.

Code tables that have been assigned to Agents as their default (in the Agent INI file) must always be saved in Client 0.

Tips:

Note: You have to log-in anew in order to apply changes to the system Client's code tables.

Defining Code Table Objects

A Code Table object definition is made up of the following pages:

To Define a Code Table Object

You can assign codes directly in the Code Table, which can be displayed in ASCII or hexadecimal (HEX) format. The cells in the table are input fields and are disabled by default. You must select a cell to enable it and assigned it a character. The following input field limitations apply:

Note: Only enabled characters are used for conversion.

You can also assign alternative characters using the function Set as Alternative Character from the context menu. These cells are darker than the rest of the cells in the Code Table. Alternative characters are used for conversion if the character assigned to that cell is disabled.

Removing a character from the table sets the cell back to the default value.

Additional Information

Your administrator can assign a default Code Table to an Agent by defining the UC_HOST_CODE parameter in the [VARIABLES] section of the Agent's INI file. The Automic Web Interface then reads the code table from the system client 0 and transfers it to the agent who then applies it to all jobs and file transfers that require character conversion