From m204wiki
Jump to navigation Jump to search

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=0Sets online return code
RETCODEB=0Sets batch (single user) return code
CLASS=IInformation class; the message can be suppressed with the X'02' bit setting of the MSGCTL parameter
AUDITMSWrites the message with line type MS to the audit trail
NOCOUNTDoes not increment the error count (ERCNT) parameter
NOTERMDoes not display the message on the user's terminal

Back to list of messages