M204.1528: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
 
m (add <var>'s)
 
Line 1: Line 1:
{{Template:M204.1528 skeleton}}
{{Template:M204.1528 skeleton}}
<P>
<P>
A <code>FOR EACH RECORD IN <i>label</i> WHERE/WITH</code> statement refers to the result of a SORT RECORDS statement. The WHERE/WITH clause is valid only when the FOR statement refers to a FIND statement or to a LIST. </P>
A <code>For Each Record In <i>label</i> Where/With</code> statement refers to the result of a <var>Sort Records</var> statement. The <var>Where/With</var> clause is valid only when the <var>For</var> statement refers to a <var>Find</var> statement or to a <var>List</var>. </P>
<p>
<p>
<b>Response:</b> Correct the program by adding the WHERE/WITH clause to a FIND statement and referring the SORT statement to the new FIND statement, or by placing the conditions in the WHERE/WITH clause in an IF statement inside the
<b>Response:</b> Correct the program by adding the <var>Where/With</var> clause to a <var>Find</var> statement and referring the <var>Sort</var> statement to the new <var>Find</var> statement, or by placing the conditions in the <var>Where/With</var> clause in an <var>If</var> statement inside the <var>For Each Record</var> loop.  
FOR EACH RECORD loop. </p>
</p>
{{Template:M204.1528 footer}}
{{Template:M204.1528 footer}}
<!-- skeleton as it was in pdf/WHERE/WITH CLAUSE IS INVALID AGAINST SORTED SET /-->
<!-- skeleton as it was in pdf/WHERE/WITH CLAUSE IS INVALID AGAINST SORTED SET /-->

Latest revision as of 23:56, 7 March 2018

M204.1528  Where​/​With clause is invalid against sorted set

A For Each Record In label Where/With statement refers to the result of a Sort Records statement. The Where/With clause is valid only when the For statement refers to a Find statement or to a List.

Response: Correct the program by adding the Where/With clause to a Find statement and referring the Sort statement to the new Find statement, or by placing the conditions in the Where/With clause in an If statement inside the For Each Record loop.

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
COMPILECompilation error

Back to list of messages