Defining file security with FILEMGMT: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (link repair)
 
(18 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<p>You can define security for a <var class="product">Model&nbsp;204</var> file either using the File Management Subsystem facility (FILEMGMT) or from the command line. For ease of use and to avoid errors, FILEMGMT (described in this chapter) is recommended. </p>
<p>
<p>For information on defining file security using the command line, see <b>See File security</b>.</p>
You can define security for a <var class="product">Model&nbsp;204</var> file either using the File Management Subsystem facility (FILEMGMT) or from the command line. For ease of use and to avoid errors, FILEMGMT is recommended. </p>
<p>Press the PF8 (FORward) key from the File Definition - Organization screen, or the PF7 (BACkward) key from the File Definition - Procedure screen. FILEMGMT displays the second file definition screen, the Security screen:</p>
<p>
Press the F8 (FORward) key from the [[Creating a file with FILEMGMT#Defining file organization|File Definition - Organization screen]], or the F7 (BACkward) key from the [[Defining file procedures with FILEMGMT|File Definition - Procedure screen]]. FILEMGMT displays the second file definition screen, the Security screen:</p>
 
<table>
<table>
<tr>
<tr><td>
<td>
<p class="code">FILEMGMT                File Definition - Security        PAGE 2 OF 3
<p class="code">FILEMGMT                File Definition - Security        PAGE 2 OF 3


  Filename: ABC                                              Inactive
  Filename: ABC                                              Inactive


  FILE ACCESS                                              OPENCTL X' 80 '
  FILE ACCESS                                              OPENCTL X' 80 '
 
   Public:          X    Semipublic: _   Private: _
   Public:          X    Semipublic:  _ Private: _


  Record Security:  _    Key:
  Record Security:  _    Key:


  REMOTE FILE ACCESS PRIVILEGES
  REMOTE FILE ACCESS PRIVILEGES
   NO/INV PWD: _  VALID PWD: _  GROUP MEMBER: _
   NO/INV PWD: _  VALID PWD: _  GROUP MEMBER: _


  DEFAULT FILE PRIVILEGES                                  PRIVDEF X' BFFF '
  DEFAULT FILE PRIVILEGES                                  PRIVDEF X' BFFF '
   File Manager:    X    Record Security Override: _    View File Parms: X
   File Manager:    X    Record Security Override: _    View File Parms: X


   RETRIEVE DATA WITH PROCEDURES
   RETRIEVE DATA WITH PROCEDURES
     Adhoc:        X    Internal:  X  External:  X
     Adhoc:        X    Internal:  X  External:  X


   UPDATE DATA WITH PROCEDURES
   UPDATE DATA WITH PROCEDURES
     Adhoc:        X    Internal:  X  External:  X
     Adhoc:        X    Internal:  X  External:  X


   INTERNAL PROCEDURES
   INTERNAL PROCEDURES
     Display/Copy:  X    Define:    X  Change:    X    Delete: X Include: X
     Display/Copy:  X    Define:    X  Change:    X    Delete: X Include: X


  DEFAULT FIELD LEVEL SECURITY
  DEFAULT FIELD LEVEL SECURITY
     SELLVL:        0    READLVL:  0  UPDTLVL:  0    ADDLVL: 0
     SELLVL:        0    READLVL:  0  UPDTLVL:  0    ADDLVL: 0


  ===>
  ===>


  1=HELp      2=          3=QUIt      4=FIElds    5=WIDen      6=COMmands
  1=HELp      2=          3=QUIt      4=FIElds    5=WIDen      6=COMmands
Line 53: Line 41:
</tr>
</tr>
</table>
</table>
<p>You use the File Definition - Security screen to specify <var class="product">Model&nbsp;204</var> security parameters for the file you are creating. When this screen is displayed for a file for the first time, FILEMGMT shows the standard <var class="product">Model&nbsp;204</var> default values for the parameters.   </p>
 
<p>For some of the parameters shown on this screen, you specify an actual parameter value. For others, you select options, and FILEMGMT uses your selections to compute an appropriate parameter value.</p>
<p>
<p>[[#Setting file security|Setting file security]] describes the type of information you enter. For more information about parameter settings, refer to the Rocket <var class="product">Model&nbsp;204</var> File Manager's Guide and to [[ Seven-Step File Load Examples#Seven-Step File Load Examples|Seven-Step File Load Examples]]. For a discussion of how to select the most appropriate options for your particular file, refer to the Rocket <var class="product">Model&nbsp;204</var> File Manager's Guide.</p>
You use the File Definition - Security screen to specify <var class="product">Model&nbsp;204</var> security parameters for the file you are creating. When this screen is displayed for a file for the first time, FILEMGMT shows the standard <var class="product">Model&nbsp;204</var> default values for the parameters. </p>
<p>The cursor is initially positioned at the first input prompt (the Public input field).</p>
<p>
For some of the parameters shown on this screen, you specify an actual parameter value. For others, you select options, and FILEMGMT uses your selections to compute an appropriate parameter value.</p>
<p>
[[#Setting file security|Setting file security]] describes the type of information you enter. For more information about parameter settings, refer to [[Model 204 security features#File security|File security]] and to [[Seven-Step File Load examples]]. For a discussion of how to select the most appropriate options for your particular file, refer to [[Model 204 security features]].</p>
<p>
The cursor is initially positioned at the first input prompt (the <b>Public</b> input field).</p>
 
==Setting file security==
==Setting file security==
<p>You can select more than one option from an option category.</p>
<p>
<p>To select an option, type X or another value as indicated.</p>
You can select more than one option from an option category.</p>
<p>To enter a null: type a space, press the ERASE EOF key, or preserve the default underscore character (_). Null indicates that you do not want to select the option. </p>
<p>
<p>Typing a character other than these is invalid, and produces an error message.</p>
To select an option, type <code>X</code> or another value as indicated.</p>
<p>FILEMGMT displays and/or prompts you for the following information.</p>
<p>
<table>
To enter a null: type a space, or preserve the default underscore character (<tt>_</tt>). Null indicates that you do not want to select the option. </p>
<p>
Typing a character other than these is invalid, and produces an error message.</p>
<p>
FILEMGMT displays and/or prompts you for the following information.</p>
 
<table class="thJustBold">
<tr class="head">
<tr class="head">
<th>Prompt</th>
<th>Prompt</th>
<th>Response</th>
<th>Response</th>
</tr>
</tr>
<tr>
<tr>
<td>Filename</td>
<th>Filename</th>
<td>FILEMGMT displays the name of the file that you entered on the primary screen, and indicates whether the file is Active or Inactive. </td>
<td>FILEMGMT displays the name of the file that you entered on the primary screen, and indicates whether the file is <b>Active</b> or <b>Inactive</b>. </td>
</tr>
</tr>
<tr>
<tr>
<td>FILE ACCESS</td>
<th>FILE ACCESS</th>
<td>
<td>
<p>Selects file access characteristics for the specified file. FILEMGMT computes the <var class="product">Model&nbsp;204</var> OPENCTL parameter from your selections and displays the computed value.</p>
<p>Selects file access characteristics for the specified file. FILEMGMT computes the <var class="product">Model&nbsp;204</var> <var>[[OPENCTL parameter|OPENCTL]]</var> parameter from your selections and displays the computed value.</p>
<p>Select just one option from the Public, Semipublic, and Private options. </p>
<p>Select just one option from the <b>Public</b>, <b>Semipublic</b>, and <b>Private</b> options. </p>
</td>
 
<table>
<tr>
<th>Prompt</th>
<th>Default</th>
<th>Response</th>
</tr>
</tr>
<tr>
<tr>
<td>Public</td>
<th>Public</th>
<td>File is a public file. The default is X. </td>
<td>X</td>
<td>File is a public file.</td>
</tr>
</tr>
<tr>
<tr>
<td>Semipublic</td>
<th>Semipublic</th>
<td>File is a semipublic file. The default is null. </td>
<td>null</td>
<td>File is a semipublic file.</td>
</tr>
</tr>
<tr>
<tr>
<td>Private</td>
<th>Private</th>
<td>File is a private file. The default is null. </td>
<td>null</td>
<td>File is a private file.</td>
</tr>
</tr>
</table>
</td></tr>
<tr>
<tr>
<td>Record Security</td>
<th>Record Security</th>
<td>File has record security in effect. The default is null. </td>
<td>File has record security in effect.
 
<table>
<tr class="head">
<th>Prompt</th>
<th>Default</th>
<th>Response</th>
</tr>
</tr>
<tr>
<tr>
<td>Key</td>
<td>Key</td>
<td>null</td>
<td>
<td>
<p>Name of the field used as the record security key. Key requires an entry if you select Record Security. The entry must be a valid field name (1-70 characters). The requirements for a valid field name are described in the Rocket <var class="product">Model&nbsp;204</var> File Manager's Guide.</p>
<p>
<p>A null entry is required unless you select Record Security. The default is null. </p>
Name of the field used as the record security key. <b>Key</b> requires an entry if you select Record Security. The entry must be a valid field name (1-70 characters). The requirements for a valid field name are described in [[Field names]].</p>
</td>
<p>
</tr>
A null entry is required unless you select <b>Record Security</b>.</p>
</td></tr>
</table>
</td></tr>
 
<tr>
<tr>
<td>REMOTE FILE ACCESS PRIVILEGES</td>
<th nowrap>REMOTE FILE ACCESS PRIVILEGES</th>
<td>Additional OPENCTL options for Parallel Query Option/204 (PQO) sites, the following options determine how a file can be accessed remotely.</td>
<td>Additional <var>OPENCTL</var> options for Parallel Query Option/204 (PQO) sites. The following options determine how a file can be accessed remotely.
 
<table>
<tr class="head">
<th>Prompt</th>
<th>Default</th>
<th>Response</th>
</tr>
</tr>
<tr>
<tr>
<td>NO/INV PWD</td>
<th>NO/INV PWD</th>
<td>Accessible remotely without a valid password.</td>
<td>N/A</td>
<td>Accessible remotely without a valid password.
</td>
</tr>
</tr>
<tr>
<tr>
<td>VALID PWD </td>
<th>VALID PWD </th>
<td>N/A</td>
<td>Accessible remotely with a valid password.</td>
<td>Accessible remotely with a valid password.</td>
</tr>
</tr>
<tr>
<tr>
<td>GROUP MEMBER </td>
<th>GROUP MEMBER </th>
<td>N/A</td>
<td>Accessible remotely as a permanent group member.</td>
<td>Accessible remotely as a permanent group member.</td>
</tr>
</tr>
</table>
</td></tr>
<tr>
<tr>
<td>DEFAULT FILE PRIVILEGES</td>
<th>DEFAULT FILE PRIVILEGES</th>
<td>Select the default user privileges for the specified file. FILEMGMT computes the <var class="product">Model&nbsp;204</var> PRIVDEF parameter from your selections and displays the computed value.</td>
<td>Select the default user privileges for the specified file. FILEMGMT computes the <var class="product">Model&nbsp;204</var> <var>[[PRIVDEF parameter|PRIVDEF]]</var> parameter from your selections and displays the computed value.
 
<table>
<tr class="head">
<th>Prompt</th>
<th>Default</th>
<th>Response</th>
</tr>
</tr>
<tr>
<tr>
<td>File Manager</td>
<th>File Manager</th>
<td>Default user privileges include file manager privileges. The default is X.  </td>
<td>X</td>
<td>Default user privileges include file manager privileges.</td>
</tr>
</tr>
<tr>
<tr>
<td>Record Security Override</td>
<th>Record Security Override</th>
<td>Default user privileges allow record security to be overridden. The default is null. </td>
<td>null</td>
<td>Default user privileges allow record security to be overridden.</td>
</tr>
</tr>
<tr>
<tr>
<td>View File Parms</td>
<th>View File Parms</th>
<td>Default user privileges allow file parameters to be viewed. The default is X. The default cannot be changed for a pre-9.0 file.  </td>
<td>X</td>
<td>Default user privileges allow file parameters to be viewed.</td>
</tr>
</tr>
</table>
</td></tr>
<tr>
<tr>
<td>RETRIEVE DATA WITH</td>
<th nowrap>RETRIEVE DATA WITH PROCEDURES</th>
<td>Select the default user privileges for PROCEDURES retrieving data by means of procedures.</td>
<td>Select the default user privileges for retrieving data by means of procedures.
 
<table>
<tr class="head">
<th>Prompt</th>
<th>Default</th>
<th>Response</th>
</tr>
</tr>
<tr>
<tr>
<td>Adhoc</td>
<th>Adhoc</th>
<td>Default user privileges allow data to be retrieved by ad hoc requests. The default is X.</td>
<td>X</td>
<td>Default user privileges allow data to be retrieved by ad hoc requests.</td>
</tr>
</tr>
<tr>
<tr>
<td>Internal</td>
<th>Internal</th>
<td>Default user privileges allow data to be retrieved by internal procedures. The default is X.</td>
<td>X</td>
<td>Default user privileges allow data to be retrieved by internal procedures.</td>
</tr>
</tr>
<tr>
<tr>
<td>External</td>
<th>External</th>
<td>Default user privileges allow data to be retrieved by external procedures. The default is X.</td>
<td>X</td>
<td>Default user privileges allow data to be retrieved by external procedures.</td>
</tr>
</tr>
</table>
</td></tr>
<tr>
<tr>
<td>UPDATE DATA WITH PROCEDURES </td>
<th>UPDATE DATA WITH PROCEDURES </th>
<td>Select the default user privileges for updating data by means of procedures.</td>
<td>Select the default user privileges for updating data by means of procedures.
 
<table>
<tr class="head">
<th>Prompt</th>
<th>Default</th>
<th>Response</th>
</tr>
</tr>
<tr>
<tr>
<td>Adhoc</td>
<th>Adhoc</th>
<td>Default user privileges allow data to be updated by ad hoc requests. The default is X.</td>
<td>X</td>
<td>Default user privileges allow data to be updated by ad hoc requests.</td>
</tr>
</tr>
<tr>
<tr>
<td>Internal</td>
<th>Internal</th>
<td>Default user privileges allow data to be updated by internal procedures. The default is X.</td>
<td>X</td>
<td>Default user privileges allow data to be updated by internal procedures.</td>
</tr>
</tr>
<tr>
<tr>
<td>External</td>
<th>External</th>
<td>Default user privileges allow data to be updated by external procedures. The default is X.</td>
<td>X</td>
<td>Default user privileges allow data to be updated by external procedures.</td>
</tr>
</tr>
</table>
</td></tr>
<tr>
<tr>
<td>INTERNAL PROCEDURES</td>
<th>INTERNAL PROCEDURES</th>
<td>Select the default user privileges for performing operations on internal procedures.</td>
<td>Select the default user privileges for performing operations on internal procedures.
 
<table>
<tr class="head">
<th>Prompt</th>
<th>Default</th>
<th>Response</th>
</tr>
</tr>
<tr>
<tr>
<td>Display/Copy</td>
<th>Display/Copy</th>
<td>Default user privileges allow internal procedures to be displayed, echoed, and copied. The default is X.</td>
<td>X</td>
<td>Default user privileges allow internal procedures to be displayed, echoed, and copied.</td>
</tr>
</tr>
<tr>
<tr>
<td>Define</td>
<th>Define</th>
<td>Default user privileges allow internal procedures to be defined. The default is X.</td>
<td>X</td>
<td>Default user privileges allow internal procedures to be defined.</td>
</tr>
</tr>
<tr>
<tr>
<td>Change</td>
<th>Change</th>
<td>Default user privileges allow changes (other than deletions) to internal procedures. The default is X.</td>
<td>X</td>
<td>Default user privileges allow changes (other than deletions) to internal procedures.</td>
</tr>
</tr>
<tr>
<tr>
<td>Delete</td>
<th>Delete</th>
<td>Default user privileges allow internal procedure to be deleted. The default is X.</td>
<td>X</td>
<td>Default user privileges allow internal procedure to be deleted.</td>
</tr>
</tr>
<tr>
<tr>
<td>Include</td>
<th>Include</th>
<td>Default user privileges allow internal procedures to be included. The default is X.</td>
<td>X</td>
<td>Default user privileges allow internal procedures to be included.</td>
</tr>
</tr>
</table>
</td></tr>
<tr>
<th>DEFAULT FIELD LEVEL SECURITY </th>
<td>Default field level security. Valid values are 0-255.
<table>
<tr>
<tr>
<td>DEFAULT FIELD LEVEL SECURITY </td>
<th>Prompt</th>
<td>Default field level security. Valid values are 0-255. The defaults are 0.</td>
<th>Default</th>
<th>Response</th>
</tr>
</tr>
<tr>
<tr>
<td>SELLVL </td>
<th>SELLVL </th>
<td>0</td>
<td>Default SELECT access.  </td>
<td>Default SELECT access.  </td>
</tr>
</tr>
<tr>
<tr>
<td>READLVL </td>
<th>READLVL </th>
<td>0</td>
<td>Default READ access. </td>
<td>Default READ access. </td>
</tr>
</tr>
<tr>
<tr>
<td>UPDTLVL </td>
<th>UPDTLVL </th>
<td>0</td>
<td>Default UPDATE access. </td>
<td>Default UPDATE access. </td>
</tr>
</tr>
<tr>
<tr>
<td>ADDLVL </td>
<th>ADDLVL </th>
<td>0</td>
<td>Default ADD access.</td>
<td>Default ADD access.</td>
</tr>
</tr>
</table>
</table>
</td></tr>
</table>
==Resetting file security==
==Resetting file security==
<ol>
<ol>
<li>Select the FILE Maintenance RESET function (number 2) from the primary screen. FILEMGMT displays the first of the reset screens, the File Parameter Reset screen. </li>
<li>Select the File maintenance <b>RESET</b> function (number 2) from the primary screen. FILEMGMT displays the first of the reset screens, the File Parameter Reset screen. </li>
 
<li>Press F8 (FORward) to display the File Security Reset screen:</li>
</ol>
</ol>
===Press PF8 (FORward) to display the File Security Reset screen:===
 
<table>
<table>
<tr>
<tr>
<td>
<td>
<p class="code">FILEMGMT                  File Security Reset Screen        Page 2 of 2
<p class="code">FILEMGMT                  File Security Reset               Page 2 of 2


  Filename: ABC                                                Inactive
  Filename: ABC                                                Inactive
  FILE ACCESS                                              OPENCTL X' 80 '
  FILE ACCESS                                              OPENCTL X' 80 '
   Public:          X    Semipublic:  _  Private:  _    Record Security:
   Public:          X    Semipublic:  _  Private:  _    Record Security:
  REMOTE FILE ACCESS PRIVILEGES
  REMOTE FILE ACCESS PRIVILEGES
   NO/INV PWD: _  VALID PWD: _  GROUP MEMBER: _
   NO/INV PWD: _  VALID PWD: _  GROUP MEMBER: _
  DEFAULT FILE PRIVILEGES                                  PRIVDEF X' BFFF '
  DEFAULT FILE PRIVILEGES                                  PRIVDEF X' BFFF '
   File Manager:    X    Record Security Override: _  View File Parms: X
   File Manager:    X    Record Security Override: _  View File Parms: X
Line 234: Line 364:
   INTERNAL PROCEDURES
   INTERNAL PROCEDURES
     Display/Copy:  X    Define:  X  Change:    X  Delete: X  Include: X
     Display/Copy:  X    Define:  X  Change:    X  Delete: X  Include: X
  DEFAULT FIELD LEVEL SECURITY
  DEFAULT FIELD LEVEL SECURITY
     SELLVL:        0    READLVL:  0  UPDTLVL:    0  ADDLVL: 0
     SELLVL:        0    READLVL:  0  UPDTLVL:    0  ADDLVL: 0


  DEFAULT PROCEDURE CLASS                PRCLDEF:    0
  DEFAULT PROCEDURE CLASS                PRCLDEF:    0
  ===>
   
===>


  1=HELp      2=          3=QUIt      4=          5=          6=COMmands
  1=HELp      2=          3=QUIt      4=          5=          6=COMmands
Line 245: Line 377:
</tr>
</tr>
</table>
</table>
<p>You use the Reset screens to change the values of <var class="product">Model&nbsp;204</var> file parameters that were originally set on the File Definition screens or the File Size Definition screen. FILEMGMT stages the file for a RESET command in response to your input.</p>
 
<p>The Reset screens display the file parameters that can be reset. File parameters not displayed on the Reset screens can be changed only by recreating the file.</p>
<p>
<p>For some of the file parameters shown on these screens, you specify an actual parameter value. For others, you select options, and FILEMGMT uses your selections to compute appropriate values for the FOPT, FRCVOPT, OPENCTL, and PRIVDEF parameters.</p>
You use the Reset screens to change the values of <var class="product">Model&nbsp;204</var> file parameters that were originally set on the File Definition screens or the [[Managing file and table size with FILEMGMT|File Size Definition screen]]. FILEMGMT stages the file for a <var>RESET</var> command in response to your input.</p>
<p>You need not fill in all values on all screens. Current parameter values are preserved for any parameters for which you do not enter values.</p>
<p>
<p>You can move freely between the two Reset screens by pressing the PF7 (BACkward) and PF8 (FORward) keys. FILEMGMT does not save any of the information you enter until you press one of the following function keys from either of the screens:</p>
The Reset screens display the file parameters that can be reset. File parameters not displayed on the Reset screens can be changed only by recreating the file.</p>
<p>
For some of the file parameters shown on these screens, you specify an actual parameter value. For others, you select options, and FILEMGMT uses your selections to compute appropriate values for the <var>FOPT</var>, <var>FRCVOPT</var>, <var>OPENCTL</var>, and <var>PRIVDEF</var> parameters.</p>
<p>
You need not fill in all values on all screens. Current parameter values are preserved for any parameters for which you do not enter values.</p>
<p>
You can move freely between the two Reset screens by pressing the F7 (BACkward) and F8 (FORward) keys. FILEMGMT does not save any of the information you enter until you press one of the following function keys from either of the screens:</p>
 
<table>
<table>
<tr>
<tr>
<td>PF6 </td>
<td>F6 </td>
<td>COMmands</td>
<td>COMmands</td>
</tr>
</tr>
<tr>
<tr>
<td>PF12</td>
<td>F12</td>
<td>END </td>
<td>END </td>
</tr>
</tr>
</table>
</table>
<p>The section [[#Input for the Security Reset screens|Input for the Security Reset screens]] describes the type of information you enter. For more information about parameter settings, refer to the <var class="product">Model&nbsp;204</var> Parameter and Command Reference. For a discussion of how to select the most appropriate options for your particular file, refer to the Rocket <var class="product">Model&nbsp;204</var> File Manager's Guide.</p>
 
<p>The cursor is initially positioned at the first input prompt on the first screen.</p>
<p>
The section [[#Input for the Security Reset screens|Input for the Security Reset screens]] describes the type of information you enter. For more information about parameter settings, refer to the [[List of Model 204 parameters]]. For a discussion of how to select the most appropriate options for your particular file, refer to [[Model 204 security features#File security|File security]].</p>
<p>
The cursor is initially positioned at the first input prompt on the first screen.</p>
 
==Input for the Security Reset screens==
==Input for the Security Reset screens==
<p>You can select more than one option from an option category.</p>
<p>
<p>To select an option, type X or a numeric value.</p>
You can select more than one option from an option category.</p>
<p>To enter a null: type a space, press the ERASE EOF key, or preserve the default underscore character (_). Null indicates that you do not want to select the option. </p>
<p>
<p>Typing a character other than these is invalid, and produces an error message.</p>
To select an option, type <code>X</code> or a numeric value.</p>
<p>FILEMGMT displays and/or prompts you for the following information.</p>
<p>
<table>
To enter a null: type a space, or preserve the default underscore character (<tt>_</tt>). Null indicates that you do not want to select the option. </p>
<p>
Typing a character other than these is invalid, and produces an error message.</p>
<p>
FILEMGMT displays and/or prompts you for the following information.</p>
 
<table class="thJustBold">
<tr class="head">
<tr class="head">
<th>Prompt</th>
<th>Prompt</th>
<th>Response</th>
<th>Response</th>
</tr>
</tr>
<tr>
<tr>
<td>Filename</td>
<th>Filename</th>
<td>FILEMGMT displays the name of the file that you entered on the primary screen, and indicates whether the file is Active or Inactive. </td>
<td>FILEMGMT displays the name of the file that you entered on the primary screen, and indicates whether the file is Active or Inactive. </td>
</tr>
</tr>
<tr>
<tr>
<td colspan="2">Screen 2: File Security Reset screen</td>
<th>FILE ACCESS</th>
<td>Select file access characteristics for the specified file. FILEMGMT computes a new value for the <var class="product">Model&nbsp;204</var> <var>OPENCTL</var> parameter from your selections and displays the computed value. Select just one option from the <b>Public</b>, <b>Semipublic</b>, and <b>Private</b> options. </td>
</tr>
</tr>
<tr>
<tr>
<td>FILE ACCESS</td>
<th>Public</th>
<td>Select file access characteristics for the specified file. FILEMGMT computes a new value for the <var class="product">Model&nbsp;204</var> OPENCTL parameter from your selections and displays the computed value. Select just one option from the Public, Semipublic, and Private options. </td>
<td>File is a public file. The default is <code>X</code>. </td>
</tr>
<tr>
<td>Public</td>
<td>File is a public file. The default is X. </td>
</tr>
</tr>
<tr>
<tr>
<td>Semipublic</td>
<th>Semipublic</th>
<td>File is a semipublic file. The default is null. </td>
<td>File is a semipublic file. The default is null. </td>
</tr>
</tr>
<tr>
<tr>
<td>Private</td>
<th>Private</th>
<td>File is a private file. The default is null.</td>
<td>File is a private file. The default is null.</td>
</tr>
</tr>
<tr>
<tr>
<td>Record Security</td>
<th>Record Security</th>
<td>File has record security in effect. The default is null.</td>
<td>File has record security in effect. The default is null.</td>
</tr>
</tr>
<tr>
<tr>
<td>REMOTE FILE ACCESS PRIVILEGES</td>
<th nowrap>REMOTE FILE ACCESS PRIVILEGES</th>
<td>Additional OPENCTL options for Parallel Query Option/204 (PQO) sites, the following options determine how a file can be accessed remotely.</td>
<td>Additional OPENCTL options for Parallel Query Option/204 (PQO) sites, the following options determine how a file can be accessed remotely.</td>
</tr>
</tr>
<tr>
<tr>
<td>NO/INV/ PWD</td>
<th>NO/INV/ PWD</th>
<td>Accessible remotely without a valid password</td>
<td>Accessible remotely without a valid password</td>
</tr>
</tr>
<tr>
<tr>
<td>VALID PWD</td>
<th>VALID PWD</th>
<td>Accessible remotely with a valid password.</td>
<td>Accessible remotely with a valid password.</td>
</tr>
</tr>
<tr>
<tr>
<td>GROUP MEMBER</td>
<th>GROUP MEMBER</th>
<td>Accessible remotely as a permanent group member.</td>
<td>Accessible remotely as a permanent group member.</td>
</tr>
</tr>
<tr>
<tr>
<td>DEFAULT PROCEDURE CLASS PRCLDEF</td>
<th>DEFAULT PROCEDURE CLASS PRCLDEF</th>
<td>
<td>Default user class for procedures, if the file is public or semipublic.  
<p>Default user class for procedures, if the file is public or semipublic. </p>
<p>
<p>Valid values are 0-255. The default is 0.</p>
Valid values are 0-255. The default is 0.</p></td>
</td>
</tr>
</tr>
<tr>
<tr>
<td>DEFAULT FILE PRIVILEGES</td>
<th>DEFAULT FILE PRIVILEGES</th>
<td>Select default user privileges characteristics for the specified file. FILEMGMT computes a new value for the <var class="product">Model&nbsp;204</var> PRIVDEF parameter from your selections and displays the computed value.</td>
<td>Select default user privileges characteristics for the specified file. FILEMGMT computes a new value for the <var class="product">Model&nbsp;204</var> <var>PRIVDEF</var> parameter from your selections and displays the computed value.</td>
</tr>
</tr>
<tr>
<tr>
<td>File Manager</td>
<th>File Manager</th>
<td>Default user privileges include file manager privileges. The default is X.</td>
<td>Default user privileges include file manager privileges. The default is X.</td>
</tr>
</tr>
<tr>
<tr>
<td>Record Security</td>
<th>Record Security</th>
<td>Default user privileges allow record security Override to be overridden. The default is null.</td>
<td>Default user privileges allow record security Override to be overridden. The default is null.</td>
</tr>
</tr>
<tr>
<tr>
<td>View File Parms</td>
<th>View File Parms</th>
<td>Default user privileges allow file parameters to be viewed. The default is X. The default cannot be changed for a pre-9.0 file.</td>
<td>Default user privileges allow file parameters to be viewed. The default is <code>X</code>. </td>
</tr>
</tr>
<tr>
<tr>
<td colspan="2">RETRIEVE DATA WITH PROCEDURES</td>
<th colspan="2">RETRIEVE DATA WITH PROCEDURES</th>
</tr>
</tr>
<tr>
<tr>
<td>Adhoc</td>
<th>Adhoc</th>
<td>Default user privileges allow data to be retrieved by ad hoc requests. The default is X.</td>
<td>Default user privileges allow data to be retrieved by ad hoc requests. The default is X.</td>
</tr>
</tr>
<tr>
<tr>
<td>Internal</td>
<th>Internal</th>
<td>Default user privileges allow data to be retrieved by internal procedures. The default is X.</td>
<td>Default user privileges allow data to be retrieved by internal procedures. The default is X.</td>
</tr>
</tr>
<tr>
<tr>
<td>External</td>
<th>External</th>
<td>Default user privileges allow data to be retrieved by external procedures. The default is X. </td>
<td>Default user privileges allow data to be retrieved by external procedures. The default is X. </td>
</tr>
</tr>
<tr>
<tr>
<td colspan="2">UPDATE DATA WITH PROCEDURES</td>
<th colspan="2">UPDATE DATA WITH PROCEDURES</th>
</tr>
</tr>
<tr>
<tr>
<td>Adhoc</td>
<th>Adhoc</th>
<td>Default user privileges allow data to be updated by ad hoc requests. The default is X.</td>
<td>Default user privileges allow data to be updated by ad hoc requests. The default is <code>X</code>.</td>
</tr>
</tr>
<tr>
<tr>
<td>Internal</td>
<th>Internal</th>
<td>Default user privileges allow data to be updated by internal procedures. The default is X.</td>
<td>Default user privileges allow data to be updated by internal procedures. The default is <code>X</code>.</td>
</tr>
</tr>
<tr>
<tr>
<td>External</td>
<th>External</th>
<td>Default user privileges allow data to be updated by external procedures. The default is X.</td>
<td>Default user privileges allow data to be updated by external procedures. The default is <code>X</code>.</td>
</tr>
</tr>
<tr>
<tr>
<td colspan="2">INTERNAL PROCEDURES</td>
<th colspan="2">INTERNAL PROCEDURES</th>
</tr>
</tr>
<tr>
<tr>
<td>Display/Copy</td>
<th>Display/Copy</th>
<td>Default user privileges allow internal procedures to be displayed, echoed, and copied. The default is X.</td>
<td>Default user privileges allow internal procedures to be displayed, echoed, and copied. The default is <code>X</code>.</td>
</tr>
</tr>
<tr>
<tr>
<td>Define</td>
<th>Define</th>
<td>Default user privileges allow internal procedures to be defined. The default is X.</td>
<td>Default user privileges allow internal procedures to be defined. The default is X.</td>
</tr>
</tr>
<tr>
<tr>
<td>Change</td>
<th>Change</th>
<td>Default user privileges allow changes (other than deletions) to internal procedures. The default is X.</td>
<td>Default user privileges allow changes (other than deletions) to internal procedures. The default is <code>X</code>.</td>
</tr>
</tr>
<tr>
<tr>
<td>Delete</td>
<th>Delete</th>
<td>Default user privileges allow internal procedures to be deleted. The default is X.</td>
<td>Default user privileges allow internal procedures to be deleted. The default is <code>X</code>.</td>
</tr>
</tr>
<tr>
<tr>
<td>Include</td>
<th>Include</th>
<td>Default user privileges allow internal procedures to be included. The default is X.</td>
<td>Default user privileges allow internal procedures to be included. The default is <code>X</code>.</td>
</tr>
</tr>
<tr>
<tr>
<td>DEFAULT FIELD LEVEL SECURITY</td>
<th>DEFAULT FIELD LEVEL SECURITY</th>
<td>Default field level security. Valid values are 0-255. The default is 0.</td>
<td>Default field level security. Valid values are 0-255. The default is 0.</td>
</tr>
</tr>
<tr>
<tr>
<td>SELLVL</td>
<th>SELLVL</th>
<td>Default SELECT access. </td>
<td>Default SELECT access. </td>
</tr>
</tr>
<tr>
<tr>
<td>READLVL</td>
<th>READLVL</th>
<td>Default READ access. </td>
<td>Default READ access. </td>
</tr>
</tr>
<tr>
<tr>
<td>UPDTLVL</td>
<th>UPDTLVL</th>
<td>Default UPDATE access. </td>
<td>Default UPDATE access. </td>
</tr>
</tr>
<tr>
<tr>
<td>ADDLVL</td>
<th>ADDLVL</th>
<td>Default ADD access.</td>
<td>Default ADD access.</td>
</tr>
</tr>
</table>
</table>
==File parameter reset commands==
==File parameter reset commands==
<p>To issue a command, press a PF key or type a command name at the prompt (===>) and press Enter.</p>
<p>
To issue a command, press a PF key or type a command name at the prompt (===>) and press Enter.</p>
 
<table>
<table>
<tr class="head">
<tr class="head">
Line 421: Line 604:
<th>Meaning</th>
<th>Meaning</th>
</tr>
</tr>
<tr>
<tr>
<td>PF1</td>
<td>F1</td>
<td>HELp</td>
<td>HELp</td>
<td>Displays HELP text for the File Parameter Reset screens.</td>
<td>Displays Help text for the File Parameter Reset screens.</td>
</tr>
</tr>
<tr>
<tr>
<td>PF3</td>
<td>F3</td>
<td>QUIt</td>
<td>QUIt</td>
<td>Exits from the File Parameter Reset screens and returns to the primary screen without changing any parameter values. </td>
<td>Exits from the File Parameter Reset screens and returns to the primary screen without changing any parameter values. </td>
</tr>
</tr>
<tr>
<tr>
<td>PF6</td>
<td>F6</td>
<td>COMmands </td>
<td>COMmands </td>
<td>Stages the file for RESET. Proceeds to the Execute Commands screens. This screen displays the staged commands that were generated for the file and allows you to select the commands you want to execute. </td>
<td>Stages the file for <var>RESET</var>. Proceeds to the [[Executing and deleting commands with FILEMGMT#Execute Commands screen|Execute Commands screen]]. This screen displays the staged commands that were generated for the file and allows you to select the commands you want to execute. </td>
</tr>
</tr>
<tr>
<tr>
<td>PF7</td>
<td>F7</td>
<td>BACkward</td>
<td>BACkward</td>
<td>Screen 2 only. Returns to the first File Parameter Reset screen. </td>
<td>Screen 2 only. Returns to the first File Parameter Reset screen. </td>
</tr>
</tr>
<tr>
<tr>
<td>PF8</td>
<td>F8</td>
<td>FORward</td>
<td>FORward</td>
<td>Screen 1 only. Proceeds to the second File Parameter Reset screen.</td>
<td>Screen 1 only. Proceeds to the second File Parameter Reset screen.</td>
</tr>
</tr>
<tr>
<tr>
<td>PF12 </td>
<td>F12 </td>
<td>END</td>
<td>END</td>
<td>Stages the file for RESET. Exits from the File Parameter Reset screen and returns to the primary screen.</td>
<td>Stages the file for <var>RESET</var>. Exits from the File Parameter Reset screen and returns to the primary screen.</td>
</tr>
</tr>
</table>
</table>
==Controlling file access with the SECURE and DESECURE commands==
==Controlling file access with the SECURE and DESECURE commands==
<p>SECURE and DESECURE are <var class="product">Model&nbsp;204</var> commands that you can use to control file access. </p>
<p>
<p>Securing a file ensures that a user cannot access a file illegally by running a <var class="product">Model&nbsp;204</var> program with a different password table. A special key in the password table serves as the key for securing a file. The key can be changed by the system manager with the LOGKEY command. </p>
<var>[[SECURE command: File|SECURE]]</var> and <var>[[DESECURE command: Overview of DESECURE|DESECURE]]</var> are <var class="product">Model&nbsp;204</var> commands that you can use to control file access. </p>
<p>When a secured file is opened, <var class="product">Model&nbsp;204</var> compares the key to a copy placed in the file by the SECURE command. The file is opened if the two fields match. If the fields do not match, the user is logged out and an error message is displayed on the operator's console.</p>
<p>
<p>Existing files can be secured or desecured. Staged files can be secured or desecured, with these exceptions:</p>
Securing a file ensures that a user cannot access a file illegally by running a <var class="product">Model&nbsp;204</var> program with a different password table. A special key in the password table serves as the key for securing a file. The key can be changed by the system manager with the <var>[[LOGKEY command|LOGKEY]]</var> command. </p>
<p>
When a secured file is opened, <var class="product">Model&nbsp;204</var> compares the key to a copy placed in the file by the <var>SECURE</var> command. The file is opened if the two fields match. If the fields do not match, the user is logged out and an error message is displayed on the operator's console.</p>
<p>
Existing files can be secured or desecured. Staged files can be secured or desecured, with these exceptions:</p>
<ul>
<ul>
<li>Files staged for SECURE cannot be desecured, and conversely, files staged for DESECURE cannot be secured.</li>
<li>Files staged for <var>SECURE</var> cannot be desecured, and conversely, files staged for <var>DESECURE</var> cannot be secured.</li>
<li>Files staged for CREATE, RECREATE, DELETE, and INITIALIZE can be neither secured nor desecured. </li>
 
<li>Files staged for <var>CREATE</var>, <var>RECREATE</var>, <var>DELETE</var>, and <var>INITIALIZE</var> can be neither secured nor desecured. </li>
</ul>
</ul>
<p>You must have file-level privileges of at least X'A000' (file manager and ad hoc data update) to issue SECURE and DESECURE commands. In this case, you actually need update but not retrieve privileges. (Refer to "File security" for a discussion of these privileges.)</p>
<p>
<p>To stage a file for the SECURE or DESECURE command:</p>
You must have file-level privileges of at least X'A000' (file manager and ad hoc data update) to issue <var>SECURE</var> and <var>DESECURE</var> commands. In this case, you actually need update but not retrieve privileges. (Refer to [[Model 204 security features#File security|File security]] for a discussion of these privileges.)</p>
<p>
To stage a file for the <var>SECURE</var> or <var>DESECURE</var> command:</p>
<ol>
<ol>
<li>Enter the file name on the primary screen.</li>
<li>Enter the file name on the primary screen.</li>
<li>Select the SECURE or DESECURE command.</li>
<li>Select the <var>SECURE</var> or <var>DESECURE</var> command.</li>
<li>Press Enter.</li>
<li>Press Enter.</li>
</ol>
</ol>


<p>FILEMGMT displays a message confirming that the file is staged for SECURE or DESECURE. You can proceed to the Execute Commands screen to execute the command.</p>
<p>FILEMGMT displays a message confirming that the file is staged for <var>SECURE</var> or <var>DESECURE</var>. You can proceed to the [[Executing and deleting commands with FILEMGMT#Execute Commands screen|Execute Commands screen]] to execute the command.</p>
 


[[Category:File management]]
[[Category:FILEMGMT application subsystem]]
[[Category:FILEMGMT application subsystem]]

Latest revision as of 23:02, 25 July 2017

You can define security for a Model 204 file either using the File Management Subsystem facility (FILEMGMT) or from the command line. For ease of use and to avoid errors, FILEMGMT is recommended.

Press the F8 (FORward) key from the File Definition - Organization screen, or the F7 (BACkward) key from the File Definition - Procedure screen. FILEMGMT displays the second file definition screen, the Security screen:

FILEMGMT File Definition - Security PAGE 2 OF 3 Filename: ABC Inactive FILE ACCESS OPENCTL X' 80 ' Public: X Semipublic: _ Private: _ Record Security: _ Key: REMOTE FILE ACCESS PRIVILEGES NO/INV PWD: _ VALID PWD: _ GROUP MEMBER: _ DEFAULT FILE PRIVILEGES PRIVDEF X' BFFF ' File Manager: X Record Security Override: _ View File Parms: X RETRIEVE DATA WITH PROCEDURES Adhoc: X Internal: X External: X UPDATE DATA WITH PROCEDURES Adhoc: X Internal: X External: X INTERNAL PROCEDURES Display/Copy: X Define: X Change: X Delete: X Include: X DEFAULT FIELD LEVEL SECURITY SELLVL: 0 READLVL: 0 UPDTLVL: 0 ADDLVL: 0 ===> 1=HELp 2= 3=QUIt 4=FIElds 5=WIDen 6=COMmands 7=BACkward 8=FORward 9=SIZe 10= 11= 12=END

You use the File Definition - Security screen to specify Model 204 security parameters for the file you are creating. When this screen is displayed for a file for the first time, FILEMGMT shows the standard Model 204 default values for the parameters.

For some of the parameters shown on this screen, you specify an actual parameter value. For others, you select options, and FILEMGMT uses your selections to compute an appropriate parameter value.

Setting file security describes the type of information you enter. For more information about parameter settings, refer to File security and to Seven-Step File Load examples. For a discussion of how to select the most appropriate options for your particular file, refer to Model 204 security features.

The cursor is initially positioned at the first input prompt (the Public input field).

Setting file security

You can select more than one option from an option category.

To select an option, type X or another value as indicated.

To enter a null: type a space, or preserve the default underscore character (_). Null indicates that you do not want to select the option.

Typing a character other than these is invalid, and produces an error message.

FILEMGMT displays and/or prompts you for the following information.

Prompt Response
Filename FILEMGMT displays the name of the file that you entered on the primary screen, and indicates whether the file is Active or Inactive.
FILE ACCESS

Selects file access characteristics for the specified file. FILEMGMT computes the Model 204 OPENCTL parameter from your selections and displays the computed value.

Select just one option from the Public, Semipublic, and Private options.

Prompt Default Response
Public X File is a public file.
Semipublic null File is a semipublic file.
Private null File is a private file.
Record Security File has record security in effect.
Prompt Default Response
Key null

Name of the field used as the record security key. Key requires an entry if you select Record Security. The entry must be a valid field name (1-70 characters). The requirements for a valid field name are described in Field names.

A null entry is required unless you select Record Security.

REMOTE FILE ACCESS PRIVILEGES Additional OPENCTL options for Parallel Query Option/204 (PQO) sites. The following options determine how a file can be accessed remotely.
Prompt Default Response
NO/INV PWD N/A Accessible remotely without a valid password.
VALID PWD N/A Accessible remotely with a valid password.
GROUP MEMBER N/A Accessible remotely as a permanent group member.
DEFAULT FILE PRIVILEGES Select the default user privileges for the specified file. FILEMGMT computes the Model 204 PRIVDEF parameter from your selections and displays the computed value.
Prompt Default Response
File Manager X Default user privileges include file manager privileges.
Record Security Override null Default user privileges allow record security to be overridden.
View File Parms X Default user privileges allow file parameters to be viewed.
RETRIEVE DATA WITH PROCEDURES Select the default user privileges for retrieving data by means of procedures.
Prompt Default Response
Adhoc X Default user privileges allow data to be retrieved by ad hoc requests.
Internal X Default user privileges allow data to be retrieved by internal procedures.
External X Default user privileges allow data to be retrieved by external procedures.
UPDATE DATA WITH PROCEDURES Select the default user privileges for updating data by means of procedures.
Prompt Default Response
Adhoc X Default user privileges allow data to be updated by ad hoc requests.
Internal X Default user privileges allow data to be updated by internal procedures.
External X Default user privileges allow data to be updated by external procedures.
INTERNAL PROCEDURES Select the default user privileges for performing operations on internal procedures.
Prompt Default Response
Display/Copy X Default user privileges allow internal procedures to be displayed, echoed, and copied.
Define X Default user privileges allow internal procedures to be defined.
Change X Default user privileges allow changes (other than deletions) to internal procedures.
Delete X Default user privileges allow internal procedure to be deleted.
Include X Default user privileges allow internal procedures to be included.
DEFAULT FIELD LEVEL SECURITY Default field level security. Valid values are 0-255.
Prompt Default Response
SELLVL 0 Default SELECT access.
READLVL 0 Default READ access.
UPDTLVL 0 Default UPDATE access.
ADDLVL 0 Default ADD access.

Resetting file security

  1. Select the File maintenance RESET function (number 2) from the primary screen. FILEMGMT displays the first of the reset screens, the File Parameter Reset screen.
  2. Press F8 (FORward) to display the File Security Reset screen:

FILEMGMT File Security Reset Page 2 of 2 Filename: ABC Inactive FILE ACCESS OPENCTL X' 80 ' Public: X Semipublic: _ Private: _ Record Security: REMOTE FILE ACCESS PRIVILEGES NO/INV PWD: _ VALID PWD: _ GROUP MEMBER: _ DEFAULT FILE PRIVILEGES PRIVDEF X' BFFF ' File Manager: X Record Security Override: _ View File Parms: X RETRIEVE DATA WITH PROCEDURES Adhoc: X Internal: X External: X UPDATE DATA WITH PROCEDURES Adhoc: X Internal: X External: X INTERNAL PROCEDURES Display/Copy: X Define: X Change: X Delete: X Include: X DEFAULT FIELD LEVEL SECURITY SELLVL: 0 READLVL: 0 UPDTLVL: 0 ADDLVL: 0 DEFAULT PROCEDURE CLASS PRCLDEF: 0 ===> 1=HELp 2= 3=QUIt 4= 5= 6=COMmands 7=BACkward 8= 9= 10= 11= 12=END

You use the Reset screens to change the values of Model 204 file parameters that were originally set on the File Definition screens or the File Size Definition screen. FILEMGMT stages the file for a RESET command in response to your input.

The Reset screens display the file parameters that can be reset. File parameters not displayed on the Reset screens can be changed only by recreating the file.

For some of the file parameters shown on these screens, you specify an actual parameter value. For others, you select options, and FILEMGMT uses your selections to compute appropriate values for the FOPT, FRCVOPT, OPENCTL, and PRIVDEF parameters.

You need not fill in all values on all screens. Current parameter values are preserved for any parameters for which you do not enter values.

You can move freely between the two Reset screens by pressing the F7 (BACkward) and F8 (FORward) keys. FILEMGMT does not save any of the information you enter until you press one of the following function keys from either of the screens:

F6 COMmands
F12 END

The section Input for the Security Reset screens describes the type of information you enter. For more information about parameter settings, refer to the List of Model 204 parameters. For a discussion of how to select the most appropriate options for your particular file, refer to File security.

The cursor is initially positioned at the first input prompt on the first screen.

Input for the Security Reset screens

You can select more than one option from an option category.

To select an option, type X or a numeric value.

To enter a null: type a space, or preserve the default underscore character (_). Null indicates that you do not want to select the option.

Typing a character other than these is invalid, and produces an error message.

FILEMGMT displays and/or prompts you for the following information.

Prompt Response
Filename FILEMGMT displays the name of the file that you entered on the primary screen, and indicates whether the file is Active or Inactive.
FILE ACCESS Select file access characteristics for the specified file. FILEMGMT computes a new value for the Model 204 OPENCTL parameter from your selections and displays the computed value. Select just one option from the Public, Semipublic, and Private options.
Public File is a public file. The default is X.
Semipublic File is a semipublic file. The default is null.
Private File is a private file. The default is null.
Record Security File has record security in effect. The default is null.
REMOTE FILE ACCESS PRIVILEGES Additional OPENCTL options for Parallel Query Option/204 (PQO) sites, the following options determine how a file can be accessed remotely.
NO/INV/ PWD Accessible remotely without a valid password
VALID PWD Accessible remotely with a valid password.
GROUP MEMBER Accessible remotely as a permanent group member.
DEFAULT PROCEDURE CLASS PRCLDEF Default user class for procedures, if the file is public or semipublic.

Valid values are 0-255. The default is 0.

DEFAULT FILE PRIVILEGES Select default user privileges characteristics for the specified file. FILEMGMT computes a new value for the Model 204 PRIVDEF parameter from your selections and displays the computed value.
File Manager Default user privileges include file manager privileges. The default is X.
Record Security Default user privileges allow record security Override to be overridden. The default is null.
View File Parms Default user privileges allow file parameters to be viewed. The default is X.
RETRIEVE DATA WITH PROCEDURES
Adhoc Default user privileges allow data to be retrieved by ad hoc requests. The default is X.
Internal Default user privileges allow data to be retrieved by internal procedures. The default is X.
External Default user privileges allow data to be retrieved by external procedures. The default is X.
UPDATE DATA WITH PROCEDURES
Adhoc Default user privileges allow data to be updated by ad hoc requests. The default is X.
Internal Default user privileges allow data to be updated by internal procedures. The default is X.
External Default user privileges allow data to be updated by external procedures. The default is X.
INTERNAL PROCEDURES
Display/Copy Default user privileges allow internal procedures to be displayed, echoed, and copied. The default is X.
Define Default user privileges allow internal procedures to be defined. The default is X.
Change Default user privileges allow changes (other than deletions) to internal procedures. The default is X.
Delete Default user privileges allow internal procedures to be deleted. The default is X.
Include Default user privileges allow internal procedures to be included. The default is X.
DEFAULT FIELD LEVEL SECURITY Default field level security. Valid values are 0-255. The default is 0.
SELLVL Default SELECT access.
READLVL Default READ access.
UPDTLVL Default UPDATE access.
ADDLVL Default ADD access.

File parameter reset commands

To issue a command, press a PF key or type a command name at the prompt (===>) and press Enter.

Key Command Meaning
F1 HELp Displays Help text for the File Parameter Reset screens.
F3 QUIt Exits from the File Parameter Reset screens and returns to the primary screen without changing any parameter values.
F6 COMmands Stages the file for RESET. Proceeds to the Execute Commands screen. This screen displays the staged commands that were generated for the file and allows you to select the commands you want to execute.
F7 BACkward Screen 2 only. Returns to the first File Parameter Reset screen.
F8 FORward Screen 1 only. Proceeds to the second File Parameter Reset screen.
F12 END Stages the file for RESET. Exits from the File Parameter Reset screen and returns to the primary screen.

Controlling file access with the SECURE and DESECURE commands

SECURE and DESECURE are Model 204 commands that you can use to control file access.

Securing a file ensures that a user cannot access a file illegally by running a Model 204 program with a different password table. A special key in the password table serves as the key for securing a file. The key can be changed by the system manager with the LOGKEY command.

When a secured file is opened, Model 204 compares the key to a copy placed in the file by the SECURE command. The file is opened if the two fields match. If the fields do not match, the user is logged out and an error message is displayed on the operator's console.

Existing files can be secured or desecured. Staged files can be secured or desecured, with these exceptions:

  • Files staged for SECURE cannot be desecured, and conversely, files staged for DESECURE cannot be secured.
  • Files staged for CREATE, RECREATE, DELETE, and INITIALIZE can be neither secured nor desecured.

You must have file-level privileges of at least X'A000' (file manager and ad hoc data update) to issue SECURE and DESECURE commands. In this case, you actually need update but not retrieve privileges. (Refer to File security for a discussion of these privileges.)

To stage a file for the SECURE or DESECURE command:

  1. Enter the file name on the primary screen.
  2. Select the SECURE or DESECURE command.
  3. Press Enter.

FILEMGMT displays a message confirming that the file is staged for SECURE or DESECURE. You can proceed to the Execute Commands screen to execute the command.