From m204wiki
Revision as of 18:50, 24 April 2018 by JAL (talk | contribs) (typo)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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=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
ECHODisplays the line that caused the error

Back to list of messages