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

Back to list of messages