M204.0179
M204.0179 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. This request would be more efficient if fieldName were KEY, NUMERIC RANGE, or ORDERED, depending upon the context.
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: For those fields where IS ALPHA was specified for an ORDERED NUMERIC field, change IS ALPHA to IS NUM, and the same applies to fields defined as ORDERED CHARACTER where IS NUM was used.
File manager response: If several of these messages appear for a given field name, consider using the REDEFINE command making the field KEY, NUMERIC RANGE, or ORDERED.
Message attributes:
| RETCODEO=0 | Sets online return code |
|---|---|
| RETCODEB=0 | Sets batch (single user) return code |
| CLASS=I | Information class; the message can be suppressed with the X'02' bit setting of the MSGCTL parameter |
| AUDITMS | Writes the message with line type MS to the audit trail |
| NOCOUNT | Does not increment the error count (ERCNT) parameter |
| NOTERM | Does not display the message on the user's terminal |