OPEN FILE command - Revision history

ELowell: /* Syntax */

2017-04-13T16:30:00Z

Syntax

← Older revision		Revision as of 16:30, 13 April 2017
Line 6:		Line 6:
	</dl>		</dl>
	==Syntax==		==Syntax==
	<p class="syntax">~~OPEN~~ [FILE] <var class="term">filename</var> [AT <var class="term">location</var>]		<p class="syntax"><b>O</b>PEN [FILE] <var class="term">filename</var> [AT <var class="term">location</var>]
	[[,<var class="term">defupdt1</var>] [,<var class="term">defupdt2</var>]]		[[,<var class="term">defupdt1</var>] [,<var class="term">defupdt2</var>]]
	</p>		</p>

ELowell at 16:27, 22 March 2017

2017-03-22T16:27:18Z

← Older revision		Revision as of 16:27, 22 March 2017
Line 132:		Line 132:
	</p>		</p>

	[[Category: ~~General user~~ commands]]		[[Category: User commands]]
	[[Category:Commands]]		[[Category:Commands]]

JAL: minor formatting

2016-11-29T20:10:49Z

minor formatting

← Older revision		Revision as of 20:10, 29 November 2016
Line 48:		Line 48:

	==Example==		==Example==
	The following command opens the <var class="product">Model 204</var> file <code>CENSUS</code> in deferred update mode. Hashed index deferred updates are written to defupdt1, <code>TAPEFIX</code>, and Ordered Index deferred updates are written to defupdt2, <code>TAPEVAR</code>:		The following command opens the <var class="product">Model 204</var> file <code>CENSUS</code> in deferred update mode. Hashed index deferred updates are written to <var class="term">defupdt1</var>, <code>TAPEFIX</code>, and Ordered Index deferred updates are written to <var class="term">defupdt2</var>, <code>TAPEVAR</code>:
	<p class="code">*** M204.0620: FILE CENSUS OPENED		<p class="code">*** M204.0620: FILE CENSUS OPENED
	<b></b>*** M204.1203: CENSUS WAS LAST UPDATED ON 89.003 JAN03 10.24.12		<b></b>*** M204.1203: CENSUS WAS LAST UPDATED ON 89.003 JAN03 10.24.12
Line 54:		Line 54:
	</p>		</p>
	<p>		<p>
	The following command opens the <var class="product">Model 204</var> file <code>CENSUS</code> in deferred update mode. All index updates are written to defupdt2, <code>TAPEVAR</code>:</p>		The following command opens the <var class="product">Model 204</var> file <code>CENSUS</code> in deferred update mode. All index updates are written to <var class="term">defupdt2</var>, <code>TAPEVAR</code>:</p>
	<p class="code"><b>OPEN FILE CENSUS,,TAPEVAR </b>		<p class="code"><b>OPEN FILE CENSUS,,TAPEVAR </b>
	<b></b>*** M204.0620: FILE CENSUS OPENED		<b></b>*** M204.0620: FILE CENSUS OPENED
Line 78:		Line 78:
	<p>		<p>
	<var class="product">Model 204</var> attempts to determine whether a file or a group is to be opened. <var class="product">Model 204</var> searches first for a temporary group that has the specified name. If no temporary group is found, <var class="product">Model 204</var> tries to open a permanent group by using that name. If a permanent group cannot be found, <var class="product">Model 204</var> searches for a file by that name. Further OPEN processing depends upon what type of file or group is actually being opened.</p>		<var class="product">Model 204</var> attempts to determine whether a file or a group is to be opened. <var class="product">Model 204</var> searches first for a temporary group that has the specified name. If no temporary group is found, <var class="product">Model 204</var> tries to open a permanent group by using that name. If a permanent group cannot be found, <var class="product">Model 204</var> searches for a file by that name. Further OPEN processing depends upon what type of file or group is actually being opened.</p>
	<p>There are three types of files:</p>		<p>
			There are three types of files:</p>
	<ul>		<ul>
	<li>		<li>

JAL: link repair

2016-11-29T20:06:59Z

link repair

← Older revision		Revision as of 20:06, 29 November 2016
Line 20:		Line 20:
	<ul>		<ul>
	<li>		<li>
	<p>~~for~~ Parallel Query Option/204 files, is 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.</p>		<p>
			For [[PQO: Overview of Parallel Query Option/204\|Parallel Query Option/204]] files, this is 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 (<tt>=</tt>) specifies that the file is local.</p>
	</li>		</li>

	<li>		<li>
	<p>If remote, must match a symbolic destination name specified in the DESTINATION parameter of the relevant local client DEFINE PROCESS command.</p>		<p>If remote, must match a symbolic destination name specified in the <var>DESTINATION</var> parameter of the relevant local client <var>DEFINE PROCESS</var> command.</p>
	</li>		</li>
	</ul>		</ul>
	</li>		</li>

	<li>		<li>
	<p><var class="term">defupdt1</var> is the name of the fixed-length deferred update data set. If this option is specified, deferred updates to KEY and NUMERIC RANGE fields are written to the fixed-length deferred update data set (1 to 8 characters in the form TAPE<var class="term">xxxx</var>).</p>		<p><var class="term">defupdt1</var> is the name of the fixed-length deferred update data set. If this option is specified, deferred updates to <var>KEY</var> and <var>NUMERIC RANGE</var> fields are written to the fixed-length deferred update data set (1 to 8 characters in the form TAPE<var class="term">xxxx</var>).</p>
	</li>		</li>

	<li>		<li>
	<p><var class="term">defupdt2</var> is the name of the variable-length deferred update data set. If this option is specified, deferred updates to ORDERED fields are written to the variable-length deferred update data set. All deferred index updates are written to defupdt2 if defupdt1 is not specified. If defupdt2 is not specified, updates to ORDERED fields are not deferred.</p>		<p><var class="term">defupdt2</var> is the name of the variable-length deferred update data set. If this option is specified, deferred updates to <var>ORDERED</var> fields are written to the variable-length deferred update data set. All deferred index updates are written to defupdt2 if defupdt1 is not specified. If defupdt2 is not specified, updates to <var>ORDERED</var> fields are not deferred.</p>
	<p>Deferred updates are updates to the <var class="product">Model 204</var> file index that are saved and applied all at the same time.</p>		<p>Deferred updates are updates to the <var class="product">Model 204</var> file index that are saved and applied all at the same time.</p>
	<p>		<p>
	For user privileges needed to open deferred update data sets through a security interface, see [[:Category:Security interfaces\|Security interfaces]].</p>		For user privileges needed to open deferred update data sets through a security interface, see [[:Category:Security interfaces\|Security interfaces]].</p>
	<p>		<p>
	For information about opening remote files in deferred update mode, see ~~the <var class="book">~~[[~~Media~~:~~M204 PQO204UserGuide V75.pdf\|Rocket Parallel Query Option/204 User's Guide~~]]~~</var>~~. </p>		For information about opening remote files in deferred update mode, see [[PQO: Remote files and scattered groups]]. </p>
	</li>		</li>
	</ul>		</ul>

	===Syntax notes===		===Syntax notes===
	A comma is required if a deferred update name is specified. If the comma is omitted, the name is ignored and no message is generated.		A comma is required if a deferred update name is specified. If the comma is omitted, the name is ignored and no message is generated.

	==Example==		==Example==
	The following command opens the <var class="product">Model 204</var> file CENSUS in deferred update mode. Hashed index deferred updates are written to defupdt1, TAPEFIX, and Ordered Index deferred updates are written to defupdt2, TAPEVAR:		The following command opens the <var class="product">Model 204</var> file <code>CENSUS</code> in deferred update mode. Hashed index deferred updates are written to defupdt1, <code>TAPEFIX</code>, and Ordered Index deferred updates are written to defupdt2, <code>TAPEVAR</code>:
	<p class="code">*** M204.0620: FILE CENSUS OPENED		<p class="code">*** M204.0620: FILE CENSUS OPENED
	<b></b>*** M204.1203: CENSUS WAS LAST UPDATED ON 89.003 JAN03 10.24.12		<b></b>*** M204.1203: CENSUS WAS LAST UPDATED ON 89.003 JAN03 10.24.12
	<b></b>*** M204.0656: UPDATES DEFERRED TO TAPEFIX TAPEVAR		<b></b>*** M204.0656: UPDATES DEFERRED TO TAPEFIX TAPEVAR
	</p>		</p>
	<p>The following command opens the <var class="product">Model 204</var> file CENSUS in deferred update mode. All index updates are written to defupdt2, TAPEVAR:</p>		<p>
			The following command opens the <var class="product">Model 204</var> file <code>CENSUS</code> in deferred update mode. All index updates are written to defupdt2, <code>TAPEVAR</code>:</p>
	<p class="code"><b>OPEN FILE CENSUS,,TAPEVAR </b>		<p class="code"><b>OPEN FILE CENSUS,,TAPEVAR </b>
	<b></b>*** M204.0620: FILE CENSUS OPENED		<b></b>*** M204.0620: FILE CENSUS OPENED
Line 57:		Line 60:
	<b></b>*** M204.0656: UPDATES DEFERRED TO TAPEVAR		<b></b>*** M204.0656: UPDATES DEFERRED TO TAPEVAR
	</p>		</p>
	<p>The following command opens the <var class="product">Model 204</var> file CENSUS in deferred update mode. Hashed index updates are written to TAPEFIX. Ordered Index updates are not deferred:</p>		<p>The following command opens the <var class="product">Model 204</var> file <code>CENSUS</code> in deferred update mode. Hashed index updates are written to <code>TAPEFIX</code>. Ordered Index updates are not deferred:</p>
	<p class="code">OPEN FILE CENSUS,TAPEFIX		<p class="code">OPEN FILE CENSUS,TAPEFIX
	<b></b>*** M204.0620: FILE CENSUS OPENED		<b></b>*** M204.0620: FILE CENSUS OPENED
Line 63:		Line 66:
	<b></b>*** M204.0656: UPDATES DEFERRED TO TAPEFIX		<b></b>*** M204.0656: UPDATES DEFERRED TO TAPEFIX
	</p>		</p>

	==Usage notes==		==Usage notes==
	<p>		<p>
Line 112:		Line 116:
	<p>		<p>
	The following psudeo-code shows how OPEN processing applies the order of precedence to <var class="product">Model 204</var> entities (file, temporary group, and permanent group) that all have the same name: <code>something</code>.</p>		The following psudeo-code shows how OPEN processing applies the order of precedence to <var class="product">Model 204</var> entities (file, temporary group, and permanent group) that all have the same name: <code>something</code>.</p>
	<p class="code"> OPEN something		<p class="code">OPEN something
	...		...
	If there is an open temp group named 'something' then		If there is an open temp group named 'something' then

ELowell: /* The logic of OPEN command processing */

2015-07-20T22:22:34Z

The logic of OPEN command processing

← Older revision		Revision as of 22:22, 20 July 2015
Line 111:		Line 111:
	====The logic of OPEN command processing====		====The logic of OPEN command processing====
	<p>		<p>
	The following psudeo-code ~~describes~~ how OPEN processing applies the order of precedence to ~~the~~ <var class="product">Model 204</var> entities-file, temporary group, permanent group-all ~~with~~ the same name: something.</p>		The following psudeo-code shows how OPEN processing applies the order of precedence to <var class="product">Model 204</var> entities (file, temporary group, and permanent group) that all have the same name: <code>something</code>.</p>
	<p class="code"> OPEN something		<p class="code"> OPEN something
	...		...

JAL: pdf now converted to wiki

2015-01-29T20:05:55Z

pdf now converted to wiki

← Older revision		Revision as of 20:05, 29 January 2015
Line 36:		Line 36:
	<p><var class="term">defupdt2</var> is the name of the variable-length deferred update data set. If this option is specified, deferred updates to ORDERED fields are written to the variable-length deferred update data set. All deferred index updates are written to defupdt2 if defupdt1 is not specified. If defupdt2 is not specified, updates to ORDERED fields are not deferred.</p>		<p><var class="term">defupdt2</var> is the name of the variable-length deferred update data set. If this option is specified, deferred updates to ORDERED fields are written to the variable-length deferred update data set. All deferred index updates are written to defupdt2 if defupdt1 is not specified. If defupdt2 is not specified, updates to ORDERED fields are not deferred.</p>
	<p>Deferred updates are updates to the <var class="product">Model 204</var> file index that are saved and applied all at the same time.</p>		<p>Deferred updates are updates to the <var class="product">Model 204</var> file index that are saved and applied all at the same time.</p>
	<p>For user privileges needed to open deferred update data sets through a security interface, see ~~the <var class="book">Rocket Model 204~~ Security ~~Interfaces Manual</var>~~.</p>		<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>		For user privileges needed to open deferred update data sets through a security interface, see [[:Category:Security interfaces\|Security interfaces]].</p>
			<p>
			For information about opening remote files in deferred update mode, see the <var class="book">[[Media:M204 PQO204UserGuide V75.pdf\|Rocket Parallel Query Option/204 User's Guide]]</var>. </p>
	</li>		</li>
	</ul>		</ul>
Line 62:		Line 64:
	</p>		</p>
	==Usage notes==		==Usage notes==
	<p>A <var class="product">Model 204</var> file is a collection of records. A file group is a collection of <var class="product">Model 204</var> files that <var class="product">Model 204</var> treats logically as a single file. An individual file can be a member of several different groups. Any user can open several files or groups during a single <var class="product">Model 204</var> session. These remain open until a CLOSE, LOGOUT, or DISCONNECT command is issued or until the user is restarted.</p>		<p>
	<p>The file or group specified in the most recent OPEN command is considered the default file or group. Thus, a successful OPEN command causes the current default file or group to be replaced. If an OPEN command is rejected, the default is not changed.</p>		A <var class="product">Model 204</var> file is a collection of records. A file group is a collection of <var class="product">Model 204</var> files that <var class="product">Model 204</var> treats logically as a single file. An individual file can be a member of several different groups. Any user can open several files or groups during a single <var class="product">Model 204</var> session. These remain open until a CLOSE, LOGOUT, or DISCONNECT command is issued or until the user is restarted.</p>
	<p>If no specific file or group specification is included in the OPEN command, as in:</p>		<p>
			The file or group specified in the most recent OPEN command is considered the default file or group. Thus, a successful OPEN command causes the current default file or group to be replaced. If an OPEN command is rejected, the default is not changed.</p>
			<p>
			If no specific file or group specification is included in the OPEN command, as in:</p>
	<p class="code">OPEN CENSUS		<p class="code">OPEN CENSUS
	</p>		</p>
	<p><var class="product">Model 204</var> attempts to determine whether a file or a group is to be opened. <var class="product">Model 204</var> searches first for a temporary group that has the specified name. If no temporary group is found, <var class="product">Model 204</var> tries to open a permanent group by using that name. If a permanent group cannot be found, <var class="product">Model 204</var> searches for a file by that name. Further OPEN processing depends upon what type of file or group is actually being opened.</p>		<p>
			<var class="product">Model 204</var> attempts to determine whether a file or a group is to be opened. <var class="product">Model 204</var> searches first for a temporary group that has the specified name. If no temporary group is found, <var class="product">Model 204</var> tries to open a permanent group by using that name. If a permanent group cannot be found, <var class="product">Model 204</var> searches for a file by that name. Further OPEN processing depends upon what type of file or group is actually being opened.</p>
	<p>There are three types of files:</p>		<p>There are three types of files:</p>
	<ul>		<ul>
Line 82:		Line 88:
	</li>		</li>
	</ul>		</ul>
	<p>If the file is public, <var class="product">Model 204</var> opens it without asking for a file password. You are given the default file privileges assigned to the file by the file manager.</p>		<p>
	<p>If the file is semi-public or private, <var class="product">Model 204</var> asks you to enter a valid password as shown:</p>		If the file is public, <var class="product">Model 204</var> opens it without asking for a file password. You are given the default file privileges assigned to the file by the file manager.</p>
	<p class="code">***M204.0347: PASSWORD		<p>
	[<i>password</i> [:<i>new password</i>]]		If the file is semi-public or private, <var class="product">Model 204</var> asks you to enter a valid password as shown:</p>
			<p class="code">***M204.0347: PASSWORD [<i>password</i> [:<i>new-password</i>]]
	</p>		</p>
	<p>where password or new password is a valid password for the file to be opened (1 to 8 characters); it cannot contain spaces, commas, or colons. Each file can have several passwords defined for it. If you enter a valid password, the file is opened with the file privileges associated with that password.</p>		<p>
	<p>For a semi-public file, if you do not know the password for the file and simply enter a carriage return, the file is opened and you are given the default privileges for the file. An invalid password also causes the file to be opened, but only default privileges are granted. For a private file, you must enter a valid password or the file is not opened. If the file privileges for a file include the ability to update data, the following message is displayed when the file is successfully opened:</p>		where <var class="term">password</var> or <var class="term">new-password</var> is a valid password for the file to be opened (1 to 8 characters); it cannot contain spaces, commas, or colons. Each file can have several passwords defined for it. If you enter a valid password, the file is opened with the file privileges associated with that password.</p>
			<p>
			For a semi-public file, if you do not know the password for the file and simply enter a carriage return, the file is opened and you are given the default privileges for the file. An invalid password also causes the file to be opened, but only default privileges are granted. For a private file, you must enter a valid password or the file is not opened. If the file privileges for a file include the ability to update data, the following message is displayed when the file is successfully opened:</p>
	<p class="code">*** M204.0620: FILE <i>filename</i> OPENED		<p class="code">*** M204.0620: FILE <i>filename</i> OPENED
	</p>		</p>
	<p>If the file privileges do not allow update, or if the OPEN occurs while <var class="product">Model 204</var> is running the RESTART to perform recovery, the following is displayed:</p>		<p>
			If the file privileges do not allow update, or if the OPEN occurs while <var class="product">Model 204</var> is running the RESTART to perform recovery, the following is displayed:</p>
	<p class="code">*** M204.0620: FILE <i>filename</i> OPENED -- NO UPDATES ALLOWED		<p class="code">*** M204.0620: FILE <i>filename</i> OPENED -- NO UPDATES ALLOWED
	</p>		</p>
	<p>With application subsystems, if you open a file defined as optional to the subsystem, you are granted the privileges assigned in the subsystem definition. Such privilege assignment takes places regardless of the default file privileges assigned the file. A file defined as required to the subsystem is opened implicitly when you enter the subsystem. </p>		<p>
	<p>If you have the appropriate user privileges (established by the login), you can change a file password at the time that the file is opened. When <var class="product">Model 204</var> prompts for the password, you can enter the current and desired password, separated by a colon, as shown above. If the old password is invalid, the new password specification is ignored. If the new password is too long, or if you do not have the appropriate privileges, <var class="product">Model 204</var> rejects the password. If both the old and the new file passwords are valid, <var class="product">Model 204</var> displays a message that the password has changed. The new file password has the same file privileges as those associated with the old password. </p>		With application subsystems, if you open a file defined as optional to the subsystem, you are granted the privileges assigned in the subsystem definition. Such privilege assignment takes places regardless of the default file privileges assigned the file. A file defined as required to the subsystem is opened implicitly when you enter the subsystem. </p>
			<p>
			If you have the appropriate user privileges (established by the login), you can change a file password at the time that the file is opened. When <var class="product">Model 204</var> prompts for the password, you can enter the current and desired password, separated by a colon, as shown above. If the old password is invalid, the new password specification is ignored. If the new password is too long, or if you do not have the appropriate privileges, <var class="product">Model 204</var> rejects the password. If both the old and the new file passwords are valid, <var class="product">Model 204</var> displays a message that the password has changed. The new file password has the same file privileges as those associated with the old password.</p>

	====The logic of OPEN command processing====		====The logic of OPEN command processing====
	<p>The following psudeo-code describes how OPEN processing applies the order of precedence to the <var class="product">Model 204</var> entities-file, temporary group, permanent group-all with the same name: something.</p>		<p>
			The following psudeo-code describes how OPEN processing applies the order of precedence to the <var class="product">Model 204</var> entities-file, temporary group, permanent group-all with the same name: something.</p>
	<p class="code"> OPEN something		<p class="code"> OPEN something
	...		...
Line 112:		Line 126:
	ifend		ifend
	</p>		</p>

	[[Category: General user commands]]		[[Category: General user commands]]
	[[Category:Commands]]		[[Category:Commands]]

ELowell: /* Syntax */

2014-02-25T19:43:02Z

Syntax

← Older revision		Revision as of 19:43, 25 February 2014
Line 30:		Line 30:

	<li>		<li>
	<p><var class="term">defupdt1</var> is the name of the fixed-length deferred update data set. If this option is specified, deferred updates to KEY and NUMERIC RANGE fields are written to the fixed-length deferred update data set (1 to 8 characters in the form ~~TAPExxxx~~).</p>		<p><var class="term">defupdt1</var> is the name of the fixed-length deferred update data set. If this option is specified, deferred updates to KEY and NUMERIC RANGE fields are written to the fixed-length deferred update data set (1 to 8 characters in the form TAPE<var class="term">xxxx</var>).</p>
	</li>		</li>

ELowell at 19:41, 25 February 2014

2014-02-25T19:41:55Z

← Older revision		Revision as of 19:41, 25 February 2014
Line 6:		Line 6:
	</dl>		</dl>
	==Syntax==		==Syntax==
	<p class="syntax">OPEN [FILE] filename [AT location]		<p class="syntax">OPEN [FILE] <var class="term">filename</var> [AT <var class="term">location</var>]
	[[,<var class="term">defupdt1</var>] [,<var class="term">defupdt2</var>]]		[[,<var class="term">defupdt1</var>] [,<var class="term">defupdt2</var>]]
	</p>		</p>
Line 13:		Line 13:
	<ul>		<ul>
	<li>		<li>
	<p>filename is the name of the <var class="product">Model 204</var> file to be opened.</p>		<p><var class="term">filename</var> is the name of the <var class="product">Model 204</var> file to be opened.</p>
	</li>		</li>

	<li>		<li>
	<p>location</p>		<p><var class="term">location</var></p>
	<ul>		<ul>
	<li>		<li>

ELowell: /* Syntax */

2013-06-27T18:37:33Z

Syntax

← Older revision		Revision as of 18:37, 27 June 2013
Line 7:		Line 7:
	==Syntax==		==Syntax==
	<p class="syntax">OPEN [FILE] filename [AT location]		<p class="syntax">OPEN [FILE] filename [AT location]
	[[,defupdt1] [,defupdt2]]		[[,<var class="term">defupdt1</var>] [,<var class="term">defupdt2</var>]]
	</p>		</p>

Line 30:		Line 30:

	<li>		<li>
	<p>defupdt1 is the name of the fixed-length deferred update data set. If this option is specified, deferred updates to KEY and NUMERIC RANGE fields are written to the fixed-length deferred update data set (1 to 8 characters in the form TAPExxxx).</p>		<p><var class="term">defupdt1</var> is the name of the fixed-length deferred update data set. If this option is specified, deferred updates to KEY and NUMERIC RANGE fields are written to the fixed-length deferred update data set (1 to 8 characters in the form TAPExxxx).</p>
	</li>		</li>

	<li>		<li>
	<p>defupdt2 is the name of the variable-length deferred update data set. If this option is specified, deferred updates to ORDERED fields are written to the variable-length deferred update data set. All deferred index updates are written to defupdt2 if defupdt1 is not specified. If defupdt2 is not specified, updates to ORDERED fields are not deferred.</p>		<p><var class="term">defupdt2</var> is the name of the variable-length deferred update data set. If this option is specified, deferred updates to ORDERED fields are written to the variable-length deferred update data set. All deferred index updates are written to defupdt2 if defupdt1 is not specified. If defupdt2 is not specified, updates to ORDERED fields are not deferred.</p>
	<p>Deferred updates are updates to the <var class="product">Model 204</var> file index that are saved and applied all at the same time.</p>		<p>Deferred updates are updates to the <var class="product">Model 204</var> file index that are saved and applied all at the same time.</p>
	<p>For user privileges needed to open deferred update data sets through a security interface, ~~refer to~~ the <var>Model 204 Security Interfaces Manual. </var></p>		<p>For user privileges needed to open deferred update data sets through a security interface, see the <var class="book">Rocket Model 204 Security Interfaces Manual</var>.</p>
	<p>For information about opening remote files in deferred update mode, see the <var>Parallel Query Option/204 User's Guide</var>. </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>
	</li>		</li>
	</ul>		</ul>
	===Syntax notes===		===Syntax notes===
	A comma is required if a deferred update name is specified. If the comma is omitted, the name is ignored and no message is generated.		A comma is required if a deferred update name is specified. If the comma is omitted, the name is ignored and no message is generated.

	==Example==		==Example==
	The following command opens the <var class="product">Model 204</var> file CENSUS in deferred update mode. Hashed index deferred updates are written to defupdt1, TAPEFIX, and Ordered Index deferred updates are written to defupdt2, TAPEVAR:		The following command opens the <var class="product">Model 204</var> file CENSUS in deferred update mode. Hashed index deferred updates are written to defupdt1, TAPEFIX, and Ordered Index deferred updates are written to defupdt2, TAPEVAR:

Alex: Automatically generated page update

2013-02-28T01:05:18Z

Automatically generated page update

New page

==Summary==
<dl>
<dt>Privileges
<dd>Any user
<dt>Function
</dl>
==Syntax==
OPEN [FILE] filename [AT location]
[[,defupdt1] [,defupdt2]]


Where:
<ul>
<li>
filename is the name of the <var class="product">Model 204</var> file to be opened.
</li>

<li>
location
<ul>
<li>
for Parallel Query Option/204 files, is 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.
</li>

<li>
If remote, must match a symbolic destination name specified in the DESTINATION parameter of the relevant local client DEFINE PROCESS command.
</li>
</ul>
</li>

<li>
defupdt1 is the name of the fixed-length deferred update data set. If this option is specified, deferred updates to KEY and NUMERIC RANGE fields are written to the fixed-length deferred update data set (1 to 8 characters in the form TAPExxxx).
</li>

<li>
defupdt2 is the name of the variable-length deferred update data set. If this option is specified, deferred updates to ORDERED fields are written to the variable-length deferred update data set. All deferred index updates are written to defupdt2 if defupdt1 is not specified. If defupdt2 is not specified, updates to ORDERED fields are not deferred.
Deferred updates are updates to the <var class="product">Model 204</var> file index that are saved and applied all at the same time.
For user privileges needed to open deferred update data sets through a security interface, refer to the <var>Model 204 Security Interfaces Manual. </var>
For information about opening remote files in deferred update mode, see the <var>Parallel Query Option/204 User's Guide</var>. 
</li>
</ul>
===Syntax notes===
A comma is required if a deferred update name is specified. If the comma is omitted, the name is ignored and no message is generated.
==Example==
The following command opens the <var class="product">Model 204</var> file CENSUS in deferred update mode. Hashed index deferred updates are written to defupdt1, TAPEFIX, and Ordered Index deferred updates are written to defupdt2, TAPEVAR:
*** M204.0620: FILE CENSUS OPENED
*** M204.1203: CENSUS WAS LAST UPDATED ON 89.003 JAN03 10.24.12
*** M204.0656: UPDATES DEFERRED TO TAPEFIX TAPEVAR

The following command opens the <var class="product">Model 204</var> file CENSUS in deferred update mode. All index updates are written to defupdt2, TAPEVAR:
OPEN FILE CENSUS,,TAPEVAR 
*** M204.0620: FILE CENSUS OPENED
*** M204.1203: CENSUS WAS LAST UPDATED ON 89.041 FEB10 16.34.27
*** M204.0656: UPDATES DEFERRED TO TAPEVAR

The following command opens the <var class="product">Model 204</var> file CENSUS in deferred update mode. Hashed index updates are written to TAPEFIX. Ordered Index updates are not deferred:
OPEN FILE CENSUS,TAPEFIX
*** M204.0620: FILE CENSUS OPENED
*** M204.1203: CENSUS WAS LAST UPDATED ON 88.335 DEC01 11.52.36
*** M204.0656: UPDATES DEFERRED TO TAPEFIX

==Usage notes==
A <var class="product">Model 204</var> file is a collection of records. A file group is a collection of <var class="product">Model 204</var> files that <var class="product">Model 204</var> treats logically as a single file. An individual file can be a member of several different groups. Any user can open several files or groups during a single <var class="product">Model 204</var> session. These remain open until a CLOSE, LOGOUT, or DISCONNECT command is issued or until the user is restarted.
The file or group specified in the most recent OPEN command is considered the default file or group. Thus, a successful OPEN command causes the current default file or group to be replaced. If an OPEN command is rejected, the default is not changed.
If no specific file or group specification is included in the OPEN command, as in:
OPEN CENSUS

<var class="product">Model 204</var> attempts to determine whether a file or a group is to be opened. <var class="product">Model 204</var> searches first for a temporary group that has the specified name. If no temporary group is found, <var class="product">Model 204</var> tries to open a permanent group by using that name. If a permanent group cannot be found, <var class="product">Model 204</var> searches for a file by that name. Further OPEN processing depends upon what type of file or group is actually being opened.
There are three types of files:
<ul>
<li>
Public
</li>

<li>
semi-public
</li>

<li>
Private
</li>
</ul>
If the file is public, <var class="product">Model 204</var> opens it without asking for a file password. You are given the default file privileges assigned to the file by the file manager.
If the file is semi-public or private, <var class="product">Model 204</var> asks you to enter a valid password as shown:
***M204.0347: PASSWORD
[password [:new password]]

where password or new password is a valid password for the file to be opened (1 to 8 characters); it cannot contain spaces, commas, or colons. Each file can have several passwords defined for it. If you enter a valid password, the file is opened with the file privileges associated with that password.
For a semi-public file, if you do not know the password for the file and simply enter a carriage return, the file is opened and you are given the default privileges for the file. An invalid password also causes the file to be opened, but only default privileges are granted. For a private file, you must enter a valid password or the file is not opened. If the file privileges for a file include the ability to update data, the following message is displayed when the file is successfully opened:
*** M204.0620: FILE filename OPENED

If the file privileges do not allow update, or if the OPEN occurs while <var class="product">Model 204</var> is running the RESTART to perform recovery, the following is displayed:
*** M204.0620: FILE filename OPENED -- NO UPDATES ALLOWED

With application subsystems, if you open a file defined as optional to the subsystem, you are granted the privileges assigned in the subsystem definition. Such privilege assignment takes places regardless of the default file privileges assigned the file. A file defined as required to the subsystem is opened implicitly when you enter the subsystem. 
If you have the appropriate user privileges (established by the login), you can change a file password at the time that the file is opened. When <var class="product">Model 204</var> prompts for the password, you can enter the current and desired password, separated by a colon, as shown above. If the old password is invalid, the new password specification is ignored. If the new password is too long, or if you do not have the appropriate privileges, <var class="product">Model 204</var> rejects the password. If both the old and the new file passwords are valid, <var class="product">Model 204</var> displays a message that the password has changed. The new file password has the same file privileges as those associated with the old password. 
====The logic of OPEN command processing====
The following psudeo-code describes how OPEN processing applies the order of precedence to the <var class="product">Model 204</var> entities-file, temporary group, permanent group-all with the same name: something.
 OPEN something
...
If there is an open temp group named 'something' then
re OPEN TEMP GROUP something
elseif there is an open perm group named 'something' then
re OPEN PERM GROUP something
elseif there is a defined temp group named 'something' then
OPEN TEMP GROUP something
elsif there is a defined perm group named 'something' then
OPEN PERM GROUP something
else
try to re OPEN or OPEN file something
ifend

[[Category: General user commands]]
[[Category:Commands]]