OPENC command: Difference between revisions

Latest revision as of 23:14, 14 April 2017

Summary

Privileges: Any user
Function: Opens a Model 204 file or a temporary or permanent group, preserving the previous default file or group

Syntax

OPENC {[FILE] filename [AT location] [[,defupdt1] [,defupdt2]] | [PERM | TEMP] [GROUP] groupname}

Where:

`filename`	The name of the `Model 204` file to be opened.
location	For Parallel Query Option/204 files, the symbolic name (as many as eight characters) that refers to the location of the node on which the remote file resides. An unquoted equal sign (=) specifies that the file is local. If remote, must match a symbolic destination name specified in the DESTINATION parameter of the relevant local client DEFINE PROCESS command.
`defupdt1`	The name (one to eight characters in the form TAPE`xxxx`) of the fixed-length deferred update data set. If you specify this option, deferred updates to the hashed index (KEY and NUMERIC RANGE fields) are written to this data set. Deferred updates are updates to the `Model 204` file that are saved and applied all at the same time. For information about opening remote files in deferred update mode, see PQO: Remote files and scattered groups.
`defupdt2`	The name (one to eight characters in the form TAPE`xxxx`) of the variable-length deferred update data set. If you specify this option, deferred updates to ORDERED fields are written to this data set. All index updates are written to `defupdt2` if `defupdt1` is not specified. If `defupdt2` is not specified, updates to ORDERED fields are not deferred.
groupname	The name of the `Model 204` file group to be opened.

Syntax notes

A comma is required if a deferred update data set is specified. If the comma is omitted, the data set is ignored and no message is generated.

If neither FILE nor GROUP is specified, Model 204 searches for a temporary group, followed by a permanent group, followed by a file. If neither TEMP nor PERM is specified, Model 204 assumes a temporary group.

Example

OPENC FILE CENSUS OPENC WEEK OPENC PERM GROUP GDATA

Usage notes

Like the OPEN command, you can use OPENC to open a file or a permanent or temporary group. Unlike OPEN, however, OPENC preserves the previous default file or group.

The syntax and use of the OPENC command is identical to that described for the OPEN command.

@@ Line 37: / Line 37: @@
 <td>The name (one to eight characters in the form TAPE<var class="term">xxxx</var>) of the fixed-length deferred update data set. If you specify this option, deferred updates to the hashed index (KEY and NUMERIC RANGE fields) are written to this data set.
 <p>Deferred updates are updates to the <var class="product">Model&nbsp;204</var> file that are saved and applied all at the same time.     </p>
-<p>For information about opening remote files in deferred update mode, see the <var class="book">Rocket Parallel Query Option/204 User's Guide.</var> </p>
+<p>For information about opening remote files in deferred update mode, see [[PQO: Remote files and scattered groups]].</p>
 </td>
 </tr>
@@ Line 66: / Line 66: @@
 <p>Like the OPEN command, you can use OPENC to open a file or a permanent or temporary group. Unlike OPEN, however, OPENC preserves the previous default file or group.</p>
 <p>The syntax and use of the OPENC command is identical to that described for the OPEN command.</p>
-[[Category: General user commands]]
+[[Category: User commands]]
 [[Category:Commands]]