M204.2878: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
 
m (link repair)
 
Line 1: Line 1:
{{Template:M204.2878 skeleton}}
{{Template:M204.2878 skeleton}}


In a <var>[[Find statement|Find]]</var> (or other recordset retrieval) statement, a retrieval condition has the following form:
In a <var>[[Find statement (find records)|Find]]</var> (or other record-set retrieval) statement, a retrieval condition has the following form:


<p class="code"><var class="term">fieldname</var> EQ WITH (<var class="term">value</var>, <var class="term">value</var>, ...)</p>
<p class="code"><var class="term">fieldname</var> EQ WITH (<var class="term">value</var>, <var class="term">value</var>, ...)</p>
Line 8: Line 8:


The retrieval condition is invalid for the <var class="term">reason</var> indicated in the message.
The retrieval condition is invalid for the <var class="term">reason</var> indicated in the message.


{{Template:M204.2878 footer}}
{{Template:M204.2878 footer}}
<!-- skeleton as it was in pdf/WITH CLAUSE INVALID: FIELD %C IN %F %C/-->
<!-- skeleton as it was in pdf/WITH CLAUSE INVALID: FIELD %C IN %F %C/-->

Latest revision as of 17:34, 24 April 2018

M204.2878  With clause invalid: field fieldname in file fileName reason

In a Find (or other record-set retrieval) statement, a retrieval condition has the following form:

fieldname EQ WITH (value, value, ...)

The fieldname in the statement could be the fieldname indicated in the message, or it could be a field-name %%variable.

The retrieval condition is invalid for the reason indicated in the message.


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
CANCELCancels the user's request
COUNTIncrements the error count (ERCNT) parameter

Back to list of messages