M204.0242: 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.0242 skeleton}}
{{Template:M204.0242 skeleton}}
<P>A FOR EACH RECORD...IN ORDER (BY) statement refers to a record set from an unsorted file, or a field name is specified following "BY" which is neither the sort key nor an ordered field. The IN ORDER option is ignored because IN ORDER implies the file is in sorted order and IN ORDER BY must be followed by the name of the sort key or an ORDERED field. When the request is executed, the records are processed in unsorted order. </P>
<P>
<p><b>Response:</b> Remove or correct the IN ORDER clause. If you must process records in sorted order, consider using the SORT statement. </p>
A <var>For Each Record...In Order [By]</var> statement refers to a record set from an unsorted file, or a field name is specified following "By" that is neither the sort key nor an ordered field. The <var>In Order</var> option is ignored, because <var>In Order</var> implies that the file is in sorted order, and <var>In Order By</var> must be followed by the name of the sort key or an <var>ORDERED</var> field. </p>
<p>
When the request is executed, the records are processed in unsorted order. </P>
<p>
<b>Response:</b> Remove or correct the <var>In Order</var> clause. If you must process records in sorted order, consider using the <var>Sort</var> statement.  
</p>
{{Template:M204.0242 footer}}
{{Template:M204.0242 footer}}
<!-- skeleton as it was in pdf/SORTKEY OR ORDERED FIELD NOT FOUND -- "IN ORDER" IGNORED /-->
<!-- skeleton as it was in pdf/SORTKEY OR ORDERED FIELD NOT FOUND -- "IN ORDER" IGNORED /-->

Latest revision as of 23:45, 21 February 2018

M204.0242  SORTKEY or ORDERED field not found -- "IN ORDER" ignored

A For Each Record...In Order [By] statement refers to a record set from an unsorted file, or a field name is specified following "By" that is neither the sort key nor an ordered field. The In Order option is ignored, because In Order implies that the file is in sorted order, and In Order By must be followed by the name of the sort key or an ORDERED field.

When the request is executed, the records are processed in unsorted order.

Response: Remove or correct the In Order clause. If you must process records in sorted order, consider using the Sort statement.

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
AUDITMSWrites the message with line type MS to the audit trail
NOCOUNTDoes not increment the error count (ERCNT) parameter
ECHODisplays the line that caused the error

Back to list of messages