The AMD2 message table in the DB2 UDB Option for CICS determines the messages returned to the client application. You can modify the AMD2 message table to customize messages using single-byte character sets (SBCSs) for your site, or to accommodate new SQLCODEs generated by updated versions of DB2.
You cannot customize Japanese or other double-byte character
set (DBCS) languages, which are handled by the Japanese Conversion Module.
For more information, see the installation chapter for the Japanese
Conversion Module in the Mainframe Connect Server Option for CICS Installation
and Administration Guide.
The AMD2 message table consists of two separate tables that share a common property: the message number. These tables, the translate table and the text table, function together to return messages to the client.
The translate table associates DB2 SQLCODEs with message numbers and sets the attributes of errors.
You can edit the translate table to add messages or to change their attributes, such as the message number, the error severity, and so on. As shipped, the AMD2 message table contains entries for SQLCODEs returned by Version 3.1 of DB2 UDB.
The text table associates message numbers with message text. You can edit the text table to change the text of messages. You can also expand it to provide message text in additional languages. Message text for U.S. English, German and French is provided with the product.
The AMD2 message table is generated during installation as one module, AMD2CAMX, which contains all the AMD2 messages and message attributes. AMD2CAMX is built with two macros, SYRTMAMX and SYRTMAMT, and it is composed of two CSECTS, SYRTMAMX and SYRTMAMT. Table 5-1 shows the members of the translate and text tables.
Message table |
LOAD module |
MACRO library |
SOURCE library |
|---|---|---|---|
Translate table |
AMD2CAMX |
SYRTMAMX |
AMD2CAMX |
Text table |
AMD2CAMX |
SYRTMAMT |
AMD2CAMX |
