Each SYRTMAMX macro entry in the translate table consists of the following DB2 error message properties:
The TYPE property indicates whether the SYRTMAMX macro entry is the initial (INITIAL) or final (FINAL) entry in the translate table, or is one of the entries in between (ENTRY). Therefore, TYPE=INITIAL occurs once at the beginning of the translate table; TYPE=FINAL occurs once at the end of the table. Examples of the TYPE=INITIAL and TYPE=FINAL are shown as follows:
SYRTMAMX TYPE=INITIAL ... (additional entries not shown) SYRTMAMX TYPE=FINAL
WARNING! Do not change the INITIAL or FINAL value.
The SQLCODE property contains the SQLCODE, a numeric status indicator returned by DB2. For messages that DB2 does not generate, such as internal error messages that AMD2 generates, the value of SQLCODE is always 0. This property contains 3 digits and a plus (+) or minus (-) sign.
The text table uses the message number to identify the appropriate message to send to the client. It represents a single SQLCODE or a group of SQLCODEs about similar situations.
WARNING! Do not change the number of non-DB2 messages (those with SQLCODE equal to 0 and MSGNR greater than or equal to 32000).
The LEVEL property indicates the severity of the error. It corresponds to the following Adaptive Server severity levels:
01–10 Status information 11–16 Client application errors 17–18 Non-fatal software or hardware errors 19–24 Fatal system errors
The STATEC class property, a 2-byte field, provides more information about DB2 errors. For non-DB2 errors, the value is 0.
The STATESC subclass property, a 3-byte field, provides more information about DB2 errors. For non-DB2 errors, the value is 0.
The LOG (logging instruction) property indicates whether to log the error in the AMD2LOG file. Sybase recommends logging serious errors. To turn logging on, specify the Y value. To turn logging off, specify the N value.
The SQLFATAL (fatal error) property indicates whether AMD2 accepts more client requests in the current invocation.
Y means that yes, the error is fatal, and therefore, no further requests are accepted from the current client connection.
N means that no, the error is not fatal, and requests are processed as usual.
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |