From m204wiki
Jump to navigation Jump to search

M204.2119  AT-MOST​/​EXACTLY-ONE constraint violation in record token​,​ field ignored: token2 ​=​ token3

An attempt was made to store, add, or insert a second occurrence of an AT-MOST-ONE or EXACTLY-ONE field in the record indicated. The second occurrence, also indicated in the message, is not added/inserted in Table B, or in any index (if applicable). The requested update is not performed. This message is issued only when no ON FIELD CONSTRAINT CONFLICT unit exists for the request.

If the failed request was from SOUL, the request is canceled and its active transaction, if any, is backed out. For failed requests from Host Language Interface, the message is accompanied by Return Code 202 (without request cancellation). For failed requests during Fastload (FLOD or FILELOAD), Fastload continues, but the file is marked "logically inconsistent" (see the FISTAT parameter).

Response: SOUL procedures that update AT-MOST-ONE or EXACTLY-ONE fields should always contain On FCC units to handle AT-MOST-ONE conflicts ($Updstat code 2) when they occur. Similarly, Host Language Interface programs should code routines to handle AT-MOST-ONE violations, as indicated by the Return Code 202. Fastload must be corrected, following a RESET of FISTAT (see below), to properly load AT-MOST-ONE fields.

File manager response: From SOUL or Host Language Interface, no response is necessary.

From Fastload (FLOAD or FILELOAD), the FISTAT parameter will have been set to X'40', "logically inconsistent," as a warning that the state of file integrity is questionable, depending on whether or not the failed request "cascaded" invalid Fastload decisions and results.

Consult with the user to determine the logical consistency ramifications of the particular Fastload in question. Reset FISTAT to X'00' once a plan for corrective action, if any, is determined.

Message attributes:

RETCODEO=0Sets online return code
RETCODEB=4Sets batch (single user) return code
CLASS=EError class; the message can be suppressed with the X'04' bit setting of the MSGCTL parameter
AUDITERWrites the message with line type ER to the audit trail
COUNTIncrements the error count (ERCNT) parameter

Back to list of messages