Translate table properties

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, and TYPE=FINAL occurs once at the end of the table. Examples of the TYPE=INITIAL and TYPE=FINAL are:

 SYRTMAMX TYPE=INITIAL 
... (additional entries not shown)
     SYRTMAMX TYPE=FINAL

The SQLCODE property contains the SQLCODE, a numeric status indicator returned by DB2 UDB. For messages that DB2 UDB 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.

The LEVEL property indicates the severity of the error. It corresponds to the following ASE 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 = the error is fatal, and no further requests are accepted from the current client connection.

• N = the error is not fatal, and requests are processed as usual.