http://wiki.signature.net/index.php?action=history&feed=atom&title=IB_Statements%2Fupdate 2026-05-04T21:29:14Z Revision history for this page on the wiki MediaWiki 1.16.0 http://wiki.signature.net/index.php?title=IB_Statements/update&diff=765&oldid=prev 2009-05-28T22:21:37Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 22:21, 28 May 2009</td> </tr><tr><td colspan="2" class="diff-lineno">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''UPDATE statement''' &nbsp;</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''UPDATE statement''' &nbsp;</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>'''Syntax:'''&nbsp; UPDATE (lun, format-statement-label) KEY=index [,EXCP=statement-label]&nbsp; &nbsp;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>'''Syntax:'''&nbsp; UPDATE (lun, format-statement-label) KEY=index [,EXCP=statement-label <ins class="diffchange diffchange-inline">| NOEXCP</ins>]&nbsp; &nbsp;</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''Discussion:'''&nbsp; The UPDATE statement modifies only specified fields in a data record of a file. &nbsp;</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''Discussion:'''&nbsp; The UPDATE statement modifies only specified fields in a data record of a file. &nbsp;</div></td></tr> <!-- diff cache key wikidb:diff:version:1.11a:oldid:349:newid:765 --> </table>

Barb http://wiki.signature.net/index.php?title=IB_Statements/update&diff=349&oldid=prev 2009-05-20T10:36:35Z

<p>New page: &#39;&#39;&#39;UPDATE statement&#39;&#39;&#39; &#39;&#39;&#39;Syntax:&#39;&#39;&#39; UPDATE (lun, format-statement-label) KEY=index [,EXCP=statement-label] &#39;&#39;&#39;Discussion:&#39;&#39;&#39; The UPDATE statement modifies only specified fields in ...</p> <p><b>New page</b></p><div>'''UPDATE statement''' <br /> <br /> '''Syntax:''' UPDATE (lun, format-statement-label) KEY=index [,EXCP=statement-label] <br /> <br /> '''Discussion:''' The UPDATE statement modifies only specified fields in a data record of a file. <br /> <br /> The UPDATE statement extracts the specified record (placing it in the user's buffer), moves the field(s) being updated into the correct position(s) in the user's buffer (as specified with a FORMAT statement), and rewrites the data in the directory with an unindexed WRITE statement. <br /> <br /> '''Note:''' Because the record is temporarily extracted during an UPDATE operation, other programs that access the same file must be prepared for the possibility of encountering an extract exception. <br /> <br /> '''Example:''' 1000 FORMAT FLAG1$,@(50);FLAG2$,@(100)<br /> <br /> .<br /> <br /> OPEN (1) &quot;FILEB&quot;<br /> <br /> .<br /> <br /> FLAG1$ = &quot;NEW&quot;<br /> <br /> FLAG2$ = &quot;TEST&quot;<br /> <br /> UPDATE (1,1000) KEY=CUSTNUM$<br /> <br /> This example shows how to use the UPDATE statement to update several fields in a data record. The FORMAT statement defines the fields to be updated, and their positions in the data record. In the Procedure Division of the program, the data variables are set to their new values, and the UPDATE statement is executed.</div>

Badge