Previous Topic: MUF_RC_DUMP_OPT (MDO)Next Topic: MUF_SMP_STATS (MFW)


MUF_RETURN_CODES (MFU)

This table allows you to determine which CA Datacom/DB return codes have occurred in this execution of the MUF. It has a key of the external return code concatenated with the internal return code.

Column Name

SQL Data Type

Nullable

Description

COUNT_CODES

INTEGER

No

Each full return code has a count of occurrences. The table has rows for only those errors that have occurred at least once. Several return codes that occur frequently in non error situations are not counted. These include, but are not restricted to, return codes: 14, 19, and 04(127). Also not counted are certain return codes that occur outside the MUF. These include, but are not restricted to, return codes: 36, 37, 57, 68, 85, and 86.

EXTERNAL_CODE

CHAR(2)

No

CA Datacom/DB passes a return code, that is, an external return code, to the Request Area of a program in response to the program issuing a CA Datacom/DB command. CA Datacom/DB also issues return codes within CA Datacom/DB messages, that is, internal return codes. All non-blank external return codes have one or more associated internal return codes. If there is only one internal return code associated with the return code, it is not separately listed in the CA Datacom/DB Message Reference Guide since the description in that case of the external and internal return codes is the same.

INTERNAL_CODE

CHAR(3)

No

See the explanation of internal codes given in the description of EXTERNAL_CODE.

MUF_NAME

CHAR(8)

No

Name of the MUF specified in the MUF Multi-User startup option or the name of the MUF job name.

SHORT_TEXT

CHAR(50)

No

Each unique return code has this short text to speed the review of errors and save time that could be spent looking up message meanings.