M204.0180
M204.0180 Table B search implied for field = fieldName in context name
A Find statement or IFFIND function must do a sequential retrieval where indexed retrieval is impossible. A Table B search results, and the MBSCAN count is exceeded. Compilation continues but the request is not executed.
The possible Find statement contexts producing this message are:
- fieldName = value, where fieldName is NON-KEY
- fieldName IS value or IS GREATER THAN value or IS LESS THAN value, where fieldName is NON-RANGE
- fieldName IS BETWEEN value1 AND value2, where fieldName is NON-RANGE
- fieldName IS AFTER value or IS BEFORE value, for any type of field
- fieldName IS PRESENT, for any type of field
- fieldName IS ALPHA ... value, for an ORDERED NUMERIC field
- fieldName IS NUM ... value, for an ORDERED CHARACTER field
Response: Reset MBSCAN, using the RESET command, and retry. Correct syntax of request if using IS ALPHA on ORDERED NUMERIC fields, or IS NUM on ORDERED CHARACTER fields.
File manager response: If several of these messages appear for the same field name, consider making the field KEY, NUMERIC RANGE, or ORDERED, depending upon the context.
System manager response: Consider changing the default value of MBSCAN, set on the User 0 parameter line, or use the Model 204 default of -1.
Message attributes:
| RETCODEO=0 | Sets online return code |
|---|---|
| RETCODEB=4 | Sets batch (single user) return code |
| CLASS=E | Error class; the message can be suppressed with the X'04' bit setting of the MSGCTL parameter |
| AUDITER | Writes the message with line type ER to the audit trail |
| COUNT | Increments the error count (ERCNT) parameter |
| ECHO | Displays the line that caused the error |