M204.0180: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
 
m (typo)
 
Line 1: Line 1:
{{Template:M204.0180 skeleton}}
{{Template:M204.0180 skeleton}}
<P>
<P>
A <var>[[Find statement (find records)|Find]]</var> statement or <var>[[IFFIND (HLI funciton)|IFFIND]]</var> function must do a sequential retrieval where indexed retrieval is impossible. A Table B search results, and the <var>[[MBSCAN parameter|MBSCAN]]</var> count is exceeded. Compilation continues but the request is not executed. </P>
A <var>[[Find statement (find records)|Find]]</var> statement or <var>[[IFFIND (HLI function)|IFFIND]]</var> function must do a sequential retrieval where indexed retrieval is impossible. A Table B search results, and the <var>[[MBSCAN parameter|MBSCAN]]</var> count is exceeded. Compilation continues but the request is not executed. </P>
<P>
<P>
The possible <var>Find</var> statement contexts producing this message are: </P>
The possible <var>Find</var> statement contexts producing this message are: </P>

Latest revision as of 18:50, 24 April 2018

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