The AMD2 message table consists of two separate tables that share a common property: the message number. These two separate 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. (Attributes include 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.
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. The following table 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 |
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |