https://m204wiki.rocketsoftware.com/index.php?action=history&feed=atom&title=M204.0242M204.0242 - Revision history2026-04-13T09:07:28ZRevision history for this page on the wikiMediaWiki 1.43.1https://m204wiki.rocketsoftware.com/index.php?title=M204.0242&diff=106041&oldid=prevJAL: add <var>'s2018-02-21T23:45:03Z<p>add <var>'s</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 23:45, 21 February 2018</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{Template:M204.0242 skeleton}}</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{Template:M204.0242 skeleton}}</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><P>A <del style="font-weight: bold; text-decoration: none;">FOR EACH RECORD</del>...<del style="font-weight: bold; text-decoration: none;">IN ORDER (BY) </del>statement refers to a record set from an unsorted file, or a field name is specified following "<del style="font-weight: bold; text-decoration: none;">BY</del>" <del style="font-weight: bold; text-decoration: none;">which </del>is neither the sort key nor an ordered field. The <del style="font-weight: bold; text-decoration: none;">IN ORDER </del>option is ignored because <del style="font-weight: bold; text-decoration: none;">IN ORDER </del>implies the file is in sorted order and <del style="font-weight: bold; text-decoration: none;">IN ORDER BY </del>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></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><P></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><p><b>Response:</b> Remove or correct the <del style="font-weight: bold; text-decoration: none;">IN ORDER </del>clause. If you must process records in sorted order, consider using the <del style="font-weight: bold; text-decoration: none;">SORT </del>statement. </p></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>A <ins style="font-weight: bold; text-decoration: none;"><var>For Each Record</ins>...<ins style="font-weight: bold; text-decoration: none;">In Order [By]</var> </ins>statement refers to a record set from an unsorted file, or a field name is specified following "<ins style="font-weight: bold; text-decoration: none;">By</ins>" <ins style="font-weight: bold; text-decoration: none;">that </ins>is neither the sort key nor an ordered field. The <ins style="font-weight: bold; text-decoration: none;"><var>In Order</var> </ins>option is ignored<ins style="font-weight: bold; text-decoration: none;">, </ins>because <ins style="font-weight: bold; text-decoration: none;"><var>In Order</var> </ins>implies <ins style="font-weight: bold; text-decoration: none;">that </ins>the file is in sorted order<ins style="font-weight: bold; text-decoration: none;">, </ins>and <ins style="font-weight: bold; text-decoration: none;"><var>In Order By</var> </ins>must be followed by the name of the sort key or an <ins style="font-weight: bold; text-decoration: none;"><var></ins>ORDERED<ins style="font-weight: bold; text-decoration: none;"></var> </ins>field. <ins style="font-weight: bold; text-decoration: none;"></p></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"><p></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>When the request is executed, the records are processed in unsorted order. </P></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><p></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><b>Response:</b> Remove or correct the <ins style="font-weight: bold; text-decoration: none;"><var>In Order</var> </ins>clause. If you must process records in sorted order, consider using the <ins style="font-weight: bold; text-decoration: none;"><var>Sort</var> </ins>statement. </div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div></p></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{Template:M204.0242 footer}}</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{Template:M204.0242 footer}}</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><!-- skeleton as it was in pdf/SORTKEY OR ORDERED FIELD NOT FOUND -- "IN ORDER" IGNORED /--></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><!-- skeleton as it was in pdf/SORTKEY OR ORDERED FIELD NOT FOUND -- "IN ORDER" IGNORED /--></div></td></tr>
</table>JALhttps://m204wiki.rocketsoftware.com/index.php?title=M204.0242&diff=105664&oldid=prevDmeWiccan: Automatically generated page update2018-02-21T20:16:52Z<p>Automatically generated page update</p>
<p><b>New page</b></p><div>{{Template:M204.0242 skeleton}}<br />
<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><br />
<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><br />
{{Template:M204.0242 footer}}<br />
<!-- skeleton as it was in pdf/SORTKEY OR ORDERED FIELD NOT FOUND -- "IN ORDER" IGNORED /--></div>DmeWiccan