$Curfile: Difference between revisions
Jump to navigation
Jump to search
m →$CURFILE and $UPDATE functions: use mixed case |
No edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| Line 6: | Line 6: | ||
<li>In arithmetic and <var>Print</var> specifications within a record loop </li> | <li>In arithmetic and <var>Print</var> specifications within a record loop </li> | ||
<li>In an <var>In</var> clause to override a default file or group in a <var>Store Record</var> statement </li> | <li>In an <var>In</var> clause to override a default file or group in a <var>[[Data_maintenance#STORE_RECORD_statement|Store Record]]</var> statement </li> | ||
</ul> | </ul> | ||
<p> | <p> | ||
| Line 20: | Line 20: | ||
<li>The <var>[[DEFCNTX parameter|DEFCNTX]]</var> parameter (which is quite similar to the <var>CURFILE</var> parameter but provides more information and with more accuracy), and see the related <var>[[APDFCNTX parameter|APDFCNTX]]</var> parameter. </li> | <li>The <var>[[DEFCNTX parameter|DEFCNTX]]</var> parameter (which is quite similar to the <var>CURFILE</var> parameter but provides more information and with more accuracy), and see the related <var>[[APDFCNTX parameter|APDFCNTX]]</var> parameter. </li> | ||
<li>The <var>[[DEFAULT command|DEFAULT]]</var> and <var>[[OPEN | <li>The <var>[[DEFAULT command|DEFAULT]]</var> and <var>[[OPEN FILE command|OPEN]]</var> commands, which reset the file/group context. </li> | ||
<li>The <var>[[OPENC command|OPENC</var>]] command, which does <b>not</b> reset the file/group context.</li> | <li>The <var>[[OPENC command|OPENC</var>]] command, which does <b>not</b> reset the file/group context.</li> | ||
Latest revision as of 15:59, 12 February 2018
The $Curfile function returns the name of the file from which the current record has been selected. If the file is remote, $Curfile also returns the location of the file (in the form filename AT location). $Curfile takes no arguments.
You can use $Curfile in two places:
- In arithmetic and Print specifications within a record loop
- In an In clause to override a default file or group in a Store Record statement
See $Curfile and $Update functions for a discussion of default files and for examples of requests using $Curfile.
You cannot use an In clause that includes both Member and $Curfile. See IN GROUP MEMBER clause for more information about the In Group Member clause.
See also
- The CURFILE parameter.
Note: It is recommended that you use
$Curfilerather than$View('CURFILE'); in some circumstances $Curfile returns more accurate information than the CURFILE parameter. - The DEFCNTX parameter (which is quite similar to the CURFILE parameter but provides more information and with more accuracy), and see the related APDFCNTX parameter.
- The DEFAULT and OPEN commands, which reset the file/group context.
- The OPENC command, which does not reset the file/group context.
- The CLOSE command, which might reset the file/group context.