Defining fields with FILEMGMT: Difference between revisions

From m204wiki
Jump to navigation Jump to search
 
(9 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<p>Prerequisite: Read the chapers on field naming conventions, field attributes, and field design.</p>
<p>
<p>FILEMGMT provides you with an interface to perform all your field maintenance operations. This section describes how to perform the following operations:</p>
Prerequisite: Read the [[Field names|field naming conventions]], [[Defining fields manually#Field attributes|field attributes]], and [[Field design|field design]] pages.</p>
<p>
FILEMGMT provides you with an interface to perform all your field maintenance operations. This section describes how to perform the following operations:</p>
<ul>
<ul>
<li>List fields in new and existing files.</li>
<li>List fields in new and existing files.</li>
<li>Select the fields you want to define, redefine, delete, and rename.</li>
<li>Select the fields you want to define, redefine, delete, and rename.</li>
<li>Define and redefine the attributes of fields.</li>
<li>Define and redefine the attributes of fields.</li>
<li>Stage fields in preparation for executing DEFINE, REDEFINE, DELETE, and RENAME commands.</li>
 
<li>Stage fields in preparation for executing <var>DEFINE</var>, <var>REDEFINE</var>, <var>DELETE</var>, and <var>RENAME</var> commands.</li>
 
<li>Copy fields and records. </li>
<li>Copy fields and records. </li>
</ul>
</ul>
==Field Name List==
 
<p>To display the Field Name List Screen, choose one of the following methods:</p>
==Field Name List screen==
<p>
To display the Field Name List screen, choose one of the following methods:</p>
<ul>
<ul>
<li>Press the PF4 (FIElds) key on a File Definition screen or the File Size Definition screen. FILEMGMT displays the File Name List screen in DEFINE mode.</li>
<li>Press the F4 (FIElds) key on a File Definition screen or the File Size Definition screen. FILEMGMT displays the File Name List screen in <var>DEFINE</var> mode.</li>
<li>Select a FIELD Maintenance function from the primary screen without specifying a particular field name. FILEMGMT displays the File Name List screen in the mode corresponding to the selected function. </li>
 
<li>Select a Field maintenance function from the primary screen without specifying a particular field name. FILEMGMT displays the File Name List screen in the mode corresponding to the selected function. </li>
</ul>
</ul>
<p>Use the Field Name List screen to:</p>
<p>
Use the Field Name List screen to:</p>
<ul>
<ul>
<li>Specify the names of the fields in a file you are creating.</li>
<li>Specify the names of the fields in a file you are creating.</li>
<li>View fields in an existing file, define additional fields, and select fields you want to redefine, delete, and rename. </li>
<li>View fields in an existing file, define additional fields, and select fields you want to redefine, delete, and rename. </li>
</ul>
</ul>
<p>If you are defining new fields for a new or existing file, FILEMGMT displays the Field Name List screen in DEFINE mode</p>
<p>
If you are defining new fields for a new or existing file, FILEMGMT displays the Field Name List screen in <var>DEFINE</var> mode:</p>
<table>
<table>
<tr>
<tr>
<td>
<td>
<p class="code">
<p class="code">FILEMGMT                    Field Name List                    Line 1 of 12
FILEMGMT                    Field Name List                    Line 1 of 12


   Enter and select with an 'X' the fields you want to DEFINE to the file
   Enter and select with an 'X' the fields you want to DEFINE to the file
Line 51: Line 62:
</tr>
</tr>
</table>
</table>
<p>In this screen, the field name list is empty, showing that no fields are defined for the file. You can type the names of fields you want to define for the file, one field per line.</p>
 
<p>If the Update Date and Time Stamp file option is set to Y on the File Definition - Organization screen, then when you navigate to the Field Name List screen, the value from the Date Time Stamp Field Name (DTSFN) parameter is placed as the first field on the Field Name List screen.</p>
<p>
<p>According to the Date Time Stamp function description:</p>
In this screen, the field name list is empty, showing that no fields are defined for the file. You can type the names of fields you want to define for the file, one field per line.</p>
<p>
If the Update Date and Time Stamp file option is set to <code>Y</code> on the File Definition - Organization screen, then when you navigate to the Field Name List screen, the value from the Date Time Stamp Field Name (DTSFN) parameter is placed as the first field on the Field Name List screen.</p>
<p>
According to the Date Time Stamp function description:</p>
<ul>
<ul>
<li>The DTSFN field name is required for all files that use the date/time stamp feature.</li>
<li>The <var>DTSFN</var> field name is required for all files that use the date/time stamp feature.</li>
<li>The default value for DTSFN is: MY DATE TIME STAMP FIELD NAME CONTAINING SPACES </li>
 
<li>The default value for <var>DTSFN</var> is: <code>MY DATE TIME STAMP FIELD NAME CONTAINING SPACES</code> </li>
</ul>
</ul>
<p>If you are redefining, deleting, or renaming fields, and you do not specify a particular field name on the primary screen, FILEMGMT displays the Field Name List screen in the mode corresponding to the requested function.</p>
<p>
<p>The following screen was invoked by selecting the REDEFINE function:</p>
If you are redefining, deleting, or renaming fields, and you do not specify a particular field name on the primary screen, FILEMGMT displays the Field Name List screen in the mode corresponding to the requested function.</p>
<p>
The following screen was invoked by selecting the <var>REDEFINE</var> function:</p>
 
<table>
<table>
<tr>
<tr><td>
<td>
<p class="code"> FILEMGMT                    Field Name List                    Line 1 of 4
<p class="code"> FILEMGMT                    Field Name List                    Line 1 of 4


Line 73: Line 91:
  _  EMPLOYEE INITIAL
  _  EMPLOYEE INITIAL
  _  EMPLOYEE LAST NAME
  _  EMPLOYEE LAST NAME




Line 89: Line 106:
</tr>
</tr>
</table>
</table>
<p>Staged fields display the command for which they are staged in the Cmd column. Nonstaged fields have a blank in the Cmd column, as in the previous screen. Staging is discussed in [[ FILEMGMT overview#Staging entries|Staging entries]].</p>
 
<p>You can scroll forward and backward to view additional field names by pressing the PF8 (FORward) and PF7 (BACkward) keys. You can scroll forward 4000 lines, which corresponds to the maximum number of field names in Table A of a file.</p>
<p>
<p>If you specified a particular field name when you selected a Define or Redefine from the primary screen, FILEMGMT does not display this screen. Instead, FILEMGMT proceeds directly to the Field Attributes screen. For Rename and Delete, you must go to this screen first before proceeding to the Field Attributes screen.</p>
Staged fields display the command for which they are staged in the <b>Cmd</b> column. Nonstaged fields have a blank in the <b>Cmd</b> column, as in the previous screen. Staging is discussed in [[FILEMGMT overview#Staging entries|Staging entries]].</p>
<p>When updates on this screen are saved, the fields are displayed in sorted order when the screen is reentered.</p>
<p>
====Field Name List Screen Input====
You can scroll forward and backward to view additional field names by pressing the F8 (FORward) and F7 (BACkward) keys. You can scroll forward 4000 lines, which corresponds to the maximum number of field names in Table A of a file.</p>
<p>FILEMGMT displays or prompts you for the following information: </p>
<p>
<table>
If you specified a particular field name when you selected a Define or Redefine from the primary screen, FILEMGMT does not display this screen. Instead, FILEMGMT proceeds directly to the Field Attributes screen. For Rename and Delete, you must go to this screen first before proceeding to the Field Attributes screen.</p>
<p>
When updates on this screen are saved, the fields are displayed in sorted order when the screen is reentered.</p>
 
====Field Name List screen input====
<p>
FILEMGMT displays 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.</td>
<td>FILEMGMT displays the name of the file that you entered on the primary screen.</td>
</tr>
</tr>
<tr>
<tr>
<td>Fieldname</td>
<th>Fieldname</th>
<td>
<td>If you are creating a new file for which no fields have been defined, the <b>Fieldname</b> lines are blank.
<p>If you are creating a new file for which no fields have been defined, the "Fieldname" lines are blank.</p>
<p>
<p>If you are viewing an existing file and did not specify a particular field name on the primary screen, FILEMGMT lists all the fields in the file. </p>
If you are viewing an existing file and did not specify a particular field name on the primary screen, FILEMGMT lists all the fields in the file. </p>
<p>Follow these steps to stage fields for a particular function. </p>
<p>
<p>To define fields: </p>
Follow these steps to stage fields for a particular function. </p>
<p>
To define fields: </p>
<ol>
<ol>
<li>If the field names are new, type in the names (1-70 characters). Use the standard <var class="product">Model&nbsp;204</var> field naming conventions described in the <var>Rocket Model&nbsp;204 F</var>ile Manager's Guide. If the field names already exist, type X to the left of the field names. </li>
<li>If the field names are new, type in the names (1-70 characters). Use the standard <var class="product">Model&nbsp;204</var> field naming conventions. If the field names already exist, type <code>X</code> to the left of the field names.  
<p>
You can remove field names that you just added to the Field Name List screen by typing <code>D</code> to the left of the newly entered names. Newly entered names display three asterisks (<b>***</b>) in the <b>Cmd</b> area if you press Enter. </p></li>
 
<li>Press F11 (ATTributes).
<p>
The Field Attributes screen displays the fields you selected in the order in which they are listed on the Field Name List screen. The fields are staged for <var>DEFINE</var> with default attributes.  </p></li>
</ol>
</ol>
<p>You can remove field names that you just added to the Field Name List screen by typing D to the left of the newly entered names. Newly entered names display three asterisks (***) in the Cmd area if you press Enter. </p>
 
<b>Press PF11 (ATTributes).</b>
<p>
<p>The Field Attributes screen displays the fields you selected in the order in which they are listed on the Field Name List screen. The fields are staged for DEFINE with default attributes.  </p>
To redefine fields: </p>
<p>To redefine fields: </p>
<ol>
<ol>
<li>Select Redefine field from the main menu. </li>
<li>Select Redefine field from the main menu. </li>
<li>Type X to the left of the field names to select them. </li>
 
<li>Type <code>X</code> to the left of the field names to select them. </li>
 
<li>Press F11 (ATTributes).
<p>
The Field Attributes screen displays the fields you selected in the order in which they are listed on the Field Name List screen. The fields are staged for <var>REDEFINE</var>. </p></li>
</ol>
</ol>
<b>Press PF11 (ATTributes).</b>
 
<p>The Field Attributes screen displays the fields you selected in the order in which they are listed on the Field Name List screen. The fields are staged for REDEFINE. </p>
<p>
<p>To delete fields: </p>
To delete fields: </p>
<ol>
<ol>
<li>Select Delete field from the main menu. </li>
<li>Select Delete field from the main menu. </li>
<li>Type X to the left of the field names to select them. </li>
 
<li>Type <code>X</code> to the left of the field names to select them. </li>
 
<li>Press one of the following to stage the fields for <var>DELETE</var>:
<p class="codeInTable">F2 (DOCument)
F4 (FILe)
F6 (COMmands)
F9 (RECords)
F11 (ATTributes)
F12 (END)
F3 (QUIt) to cancel the deletion
</p>
<p>
Requesting a field deletion may generate a <var>REDEFINE</var> command for each record that the field cross-references. Each record's average length is decreased by the field's average length multiplied by the field percent rate for the record. </p></li>
</ol>
</ol>
<b>Press one of the following to stage the fields for DELETE:</b>
 
<p>PF2 (DOCument)
<p>
PF4 (FILe)
To rename fields: </p>
PF6 (COMmands)
PF9 (RECords)
PF11 (ATTributes)
PF12 (END)
PF3 (QUIt) to cancel the deletion</p>
</td>
</tr>
<tr>
<td>Fieldname (continued)</td>
<td>
<p>Requesting a field deletion may generate a REDEFINE command for each record that the field cross-references. Each record's average length is decreased by the field's average length multiplied by the field percent rate for the record. </p>
<p>To rename fields: </p>
<ol>
<ol>
<li>Select Rename Field from the main menu. </li>
<li>Select Rename Field from the main menu. </li>
<li>Type over the existing names. </li>
<li>Type over the existing names. </li>
</ol>
 
<b>Type X to the left of the field names to select them.</b>
<li>Type <code>X</code> to the left of the field names to select them. </li>
<b>Press one of the following to stage the fields for RENAME:</b>
 
<p>PF2 (DOCument)  
<li>Press one of the following to stage the fields for <var>RENAME</var>:
PF4 (FILe)  
<p class="codeInTable">F2 (DOCument)  
PF6 (COMmands)  
F4 (FILe)  
PF9 (RECords)  
F6 (COMmands)  
PF11 (ATTributes)  
F9 (RECords)  
PF12 (END)
F11 (ATTributes)  
PF3 (QUIt) to cancel the operation </p>
F12 (END)
</td>
F3 (QUIt) to cancel the operation </p></li></ol>
</td></tr>
 
<tr>
<th>Cmd </th>
<td>Displays the status of the field shown on the line.
<p>
If the field is currently staged, FILEMGMT displays the command that was generated for the field. The command is one of the following:</p>
<table class="thJustBold">
<tr><th>***</th><td>Field name is new. </td></tr>
<tr><th>DEF</th><td>Field is being defined. </td></tr>
<tr><th>RED</th><td>Field is being redefined. </td></tr>
<tr><th>DEL</th><td>Field is being deleted. </td></tr>
<tr><th>REN</th><td>Field is being renamed. </td></tr>
<tr><th>R/R</th><td>Field is being redefined and renamed. </td></tr>
</table>
<p>
Field operations might be staged if you begin to define, redefine, delete, or rename fields and then end your FILEMGMT session without executing the commands that were generated. When you begin a new session, these fields are shown as being staged. </p>
<p>
If the field is not currently staged, this column is blank. </p>
<p>
If a field name is added during a <var>DEFINE</var> operation and you press Enter, this column contains three asterisks (<b>***</b>). </p>
<p>
A record's <b>Cmd</b> status determines whether you can issue a particular command for the record. The Command status table below summarizes your options (where an <code>X</code> indicates the command is valid for the record).</p>
<table>
<tr class="head">
<th colspan="8">Command Status</th>
</tr>
<tr class="head">
<th rowspan="2">Command</th>
<th rowspan="2">New</th>
<th colspan="5">Staged as</th>
<th rowspan="2">Existing</th>
</tr>
<tr class="head">
<th>***</th>
<th>DEFINE</th>
<th>REDEFINE</th>
<th>DELETE</th>
<th>RENAME</th>
</tr>
<tr>
<td>DEFINE</td>
<td>X</td>
<td>X</td>
<td>X</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>REDEFINE</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>X</td>
<td>&nbsp;</td>
<td>X</td>
<td>X</td>
</tr>
<tr>
<td>DELETE</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>X</td>
<td>&nbsp;</td>
<td>X</td>
</tr>
</tr>
<tr>
<tr>
<td>Cmd </td>
<td>RENAME</td>
<td>
<td>&nbsp;</td>
<p>Displays the status of the field shown on the line. </p>
<td>&nbsp;</td>
<p>If the field is currently staged, FILEMGMT displays the command that was generated for the field. The command is one of the following:</p>
<td>&nbsp;</td>
<p class="code"><b></b>***  Field name is new.
<td>X</td>
DEF  Field is being defined.   
<td>&nbsp;</td>
RED  Field is being redefined.   
<td>X</td>
DEL  Field is being deleted.   
<td>X</td>
REN  Field is being renamed.   
R/R  Field is being redefined and renamed
</p>
<p>Field operations might be staged if you begin to define, redefine, delete, or rename fields and then end your FILEMGMT session without executing the commands that were generated. When you begin a new session, these fields are shown as being staged. </p>
<p>If the field is not currently staged, this column is blank. </p>
<p>If a field name is added during a DEFINE operation and you press Enter, this column contains three asterisks (***). </p>
<p>A field's Cmd status determines whether you can issue a particular command for the field. The table in summarizes your options; an X indicates the command is valid for the field.</p>
</td>
</tr>
</tr>
</table>
</td></tr>
</table>
</table>


====Field Name List screen commands====
====Field Name List screen 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 (<b>===></b>) and press Enter.</p>
<table>
<table>
<tr class="head">
<tr class="head">
Line 187: Line 298:
<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 Field Name List screen. </td>
<td>Displays Help text for the Field Name List screen. </td></tr>
</tr>
 
<tr>
<tr>
<td>PF2 </td>
<td>F2 </td>
<td>DOCument </td>
<td>DOCument </td>
<td>Invokes the Dictionary/204 Documentation facility. Place the cursor over the field name that you want to document and press PF2. Changes to the Field Name List screen are saved in the dictionary.</td>
<td>Invokes the Dictionary/204 Documentation facility. Place the cursor over the field name that you want to document and press F2. Changes to the Field Name List screen are saved in the dictionary.</td></tr>
</tr>
 
<tr>
<tr>
<td>PF3 </td>
<td>F3 </td>
<td>QUIt </td>
<td>QUIt </td>
<td>Exits from the Field Name List screen and returns to the previous screen without making any changes. </td>
<td>Exits from the Field Name List screen and returns to the previous screen without making any changes. </td></tr>
</tr>
 
<tr>
<tr>
<td>PF4 </td>
<td>F4 </td>
<td>FILe </td>
<td>FILe </td>
<td>Proceeds to the File Definition - Organization screen, if the file is new. Proceeds to the File Parameter Reset screen, if the file already exists. Changes to the Field Name List screen are saved in the dictionary. </td>
<td>Proceeds to the [[Creating a file with FILEMGMT#Defining file organization|File Definition - Organization screen]], if the file is new. Proceeds to the File Parameter Reset screen, if the file already exists. Changes to the Field Name List screen are saved in the dictionary. </td></tr>
</tr>
 
<tr>
<tr>
<td>PF6 </td>
<td>F6 </td>
<td>COMmands </td>
<td>COMmands </td>
<td>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. Changes to the Field Name List screen are saved in the dictionary. </td>
<td>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. Changes to the Field Name List screen are saved in the dictionary. </td>
</tr>
</tr>
<tr>
<tr>
<td>PF7 </td>
<td>F7 </td>
<td>BACkward </td>
<td>BACkward </td>
<td>Scrolls backward one screen. If you type BAC at the prompt (===>), followed by a number, FILEMGMT scrolls backward the specified number of lines. </td>
<td>Scrolls backward one screen. If you type <code>BAC</code> at the prompt (<b>===></b>), followed by a number, FILEMGMT scrolls backward the specified number of lines. </td></tr>
</tr>
 
<tr>
<tr>
<td>PF8 </td>
<td>F8 </td>
<td>FORward </td>
<td>FORward </td>
<td>Scrolls forward one screen. If you type FOR at the prompt (===>), followed by a number, FILEMGMT scrolls forward the specified number of lines. </td>
<td>Scrolls forward one screen. If you type <code>FOR</code> at the prompt (<b>===></b>), followed by a number, FILEMGMT scrolls forward the specified number of lines. </td>
</tr>
</tr>
<tr>
<tr>
<td>PF9 </td>
<td>F9 </td>
<td>RECords </td>
<td>RECords </td>
<td>Proceeds to the Record Name List screen. This screen lists the records in the file. Changes to the Field Name List screen are saved in the dictionary.</td>
<td>Proceeds to the Record Name List screen. This screen lists the records in the file. Changes to the Field Name List screen are saved in the dictionary.</td></tr>
</tr>
 
<tr>
<tr>
<td>PF11 </td>
<td>F11 </td>
<td>ATTributes </td>
<td>ATTributes </td>
<td>
<td>Proceeds to the [[Defining field attributes with FILEMGMT#Field Attribute screen: initial defaults|Field Attribute screen]]. This screen defines attributes for the fields you just selected from the list. Changes to the Field Name List screen are saved in the dictionary.  
<p>Proceeds to the Field Attributes screen. This screen defines attributes for the fields you just selected from the list. Changes to the Field Name List screen are saved in the dictionary. </p>
<p>
<p>When you return from the Field Attributes screen, the Xs you originally entered on the Field Name List screen:</p>
When you return from the Field Attributes screen, the <code>X</code>s you originally entered on the Field Name List screen:</p>
<ul>
<ul>
<li>Are removed from the prefix area of fields that were processed by pressing PF11 (NEXtfld), or PF12 (END) on the Field Attributes screen.</li>
<li>Are removed from the prefix area of fields that were processed by pressing F11 (NEXtfld), or F12 (END) on the Field Attributes screen.</li>
 
<li>Remain in the prefix area of fields that were not processed.</li>
<li>Remain in the prefix area of fields that were not processed.</li>
</ul>
</ul></td></tr>
</td>
 
</tr>
<tr>
<tr>
<td>PF12 </td>
<td>F12 </td>
<td>END </td>
<td>END </td>
<td>Exits from the Field Name List screen and returns to the primary screen. Changes to the Field Name List screen are saved in the dictionary.</td>
<td>Exits from the Field Name List screen and returns to the FILEMGMT primary screen. Changes to the Field Name List screen are saved in the dictionary.</td></tr>
</tr>
</table>
</table>
===Retaining field names when initializing the file===
===Retaining field names when initializing the file===
<p>The File Initialize screen enables you to keep field definitions (using KEEPDEFS) when the file is initialized.</p>
<p>
The File Initialize screen enables you to keep field definitions (using <var>KEEPDEFS</var>) when the file is initialized.</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 INITIALIZE command.</li>
 
<li>Select the <b>INITIALIZE</b> command.</li>
 
<li>Press Enter. </li>
<li>Press Enter. </li>
</ol>
</ol>
<p>The File Initialize screen is displayed:</p>
<p>
The File Initialize screen is displayed:</p>
 
<table>
<table>
<tr>
<tr>
Line 276: Line 395:


<b></b>===>
<b></b>===>
FIM015 Use PF3 to cancel the DELETE Command or PF6/PF12 to process
FIM015 Use PF3 to cancel the DELETE Command or PF6/PF12 to process
1=HELp      2=          3=QUIt      4=          5=          6=COMmands
1=HELp      2=          3=QUIt      4=          5=          6=COMmands
Line 282: Line 402:
</tr>
</tr>
</table>
</table>
<p>The File Initialize screen duplicates the information on the File Size Definition screen.</p>
 
<p>The screen has only one input field: Keep Field Definitions? N. The default is N. If you change it to Y, the INITIALIZE command is generated with the KEEPDEFS option which retains the field names when the file is initialized. After deciding whether to keep the field definitions, you can select one of the following File Initialize commands.</p>
<p>
The File Initialize screen duplicates the information on the File Size Definition screen.</p>
<p>
The screen has only one input field: <b>Keep Field Definitions?</b>. <code>N</code> is the default. If you change it to <code>Y</code>, the <var>INITIALIZE</var> command is generated with the <var>KEEPDEFS</var> option which retains the field names when the file is initialized. After deciding whether to keep the field definitions, you can select one of the File Initialize commands in the following subsection.</p>
 
====File Initialize screen commands====
====File Initialize screen 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 (<b>===></b>) and press Enter. </p>
 
<table>
<table>
<tr class="head">
<tr class="head">
Line 292: Line 418:
<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 Initialize screen.</td>
<td>Displays Help text for the File Initialize screen.</td></tr>
</tr>
 
<tr>
<tr>
<td>PF3</td>
<td>F3</td>
<td>QUIt</td>
<td>QUIt</td>
<td>Exits from the File Initialize screen and returns to the primary screen without making any changes. </td>
<td>Exits from the File Initialize screen and returns to the primary screen without making any changes. </td></tr>
</tr>
 
<tr>
<tr>
<td>PF6 </td>
<td>F6 </td>
<td>COMmands </td>
<td>COMmands </td>
<td>Stages the file for INITIALIZE. 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.</td>
<td>Stages the file for <var>INITIALIZE</var>. 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.</td></tr>
</tr>
 
<tr>
<tr>
<td>PF12 </td>
<td>F12 </td>
<td>END</td>
<td>END</td>
<td>Stages the file for INITIALIZE. Exits from the File Initialize screen and returns to the primary screen.</td>
<td>Stages the file for <var>INITIALIZE</var>. Exits from the File Initialize screen and returns to the primary screen.</td>
</tr>
</tr>
</table>
</table>
<p>&nbsp;</p>
 
[[Category:File management]]
 
[[Category:FILEMGMT application subsystem]]
[[Category:FILEMGMT application subsystem]]

Latest revision as of 21:12, 13 May 2014

Prerequisite: Read the field naming conventions, field attributes, and field design pages.

FILEMGMT provides you with an interface to perform all your field maintenance operations. This section describes how to perform the following operations:

  • List fields in new and existing files.
  • Select the fields you want to define, redefine, delete, and rename.
  • Define and redefine the attributes of fields.
  • Stage fields in preparation for executing DEFINE, REDEFINE, DELETE, and RENAME commands.
  • Copy fields and records.

Field Name List screen

To display the Field Name List screen, choose one of the following methods:

  • Press the F4 (FIElds) key on a File Definition screen or the File Size Definition screen. FILEMGMT displays the File Name List screen in DEFINE mode.
  • Select a Field maintenance function from the primary screen without specifying a particular field name. FILEMGMT displays the File Name List screen in the mode corresponding to the selected function.

Use the Field Name List screen to:

  • Specify the names of the fields in a file you are creating.
  • View fields in an existing file, define additional fields, and select fields you want to redefine, delete, and rename.

If you are defining new fields for a new or existing file, FILEMGMT displays the Field Name List screen in DEFINE mode:

FILEMGMT Field Name List Line 1 of 12 Enter and select with an 'X' the fields you want to DEFINE to the file Filename: VEHICLES | Fieldname Cmd -------------------------------------------------------------------------- X MY DATE TIME STAMP FIELD NAME CONTAINING SPACES _ ______________________________________________________________________ _ ______________________________________________________________________ _ ______________________________________________________________________ _ ______________________________________________________________________ _ ______________________________________________________________________ _ ______________________________________________________________________ _ ______________________________________________________________________ _ ______________________________________________________________________ _ ______________________________________________________________________ _ ______________________________________________________________________ _ ______________________________________________________________________ ===> 1=HELp 2=DOCument 3=QUIt 4=FILe 5= 6=COMmands 7= 8=FORward 9=RECords 10= 11=ATTributes 12=END

In this screen, the field name list is empty, showing that no fields are defined for the file. You can type the names of fields you want to define for the file, one field per line.

If the Update Date and Time Stamp file option is set to Y on the File Definition - Organization screen, then when you navigate to the Field Name List screen, the value from the Date Time Stamp Field Name (DTSFN) parameter is placed as the first field on the Field Name List screen.

According to the Date Time Stamp function description:

  • The DTSFN field name is required for all files that use the date/time stamp feature.
  • The default value for DTSFN is: MY DATE TIME STAMP FIELD NAME CONTAINING SPACES

If you are redefining, deleting, or renaming fields, and you do not specify a particular field name on the primary screen, FILEMGMT displays the Field Name List screen in the mode corresponding to the requested function.

The following screen was invoked by selecting the REDEFINE function:

FILEMGMT Field Name List Line 1 of 4 Select the fields you want to REDEFINE with an 'X' Filename: ABC | Fieldname Cmd ----------------------------------------------------------------------- _ EMPLOYEE FIRST NAME _ EMPLOYEE ID _ EMPLOYEE INITIAL _ EMPLOYEE LAST NAME ===> 1=HELp 2=DOCument 3=QUIt 4=FILe 5= 6=COMmands 7= 8= 9=RECords 10= 11=ATTributes 12=END

Staged fields display the command for which they are staged in the Cmd column. Nonstaged fields have a blank in the Cmd column, as in the previous screen. Staging is discussed in Staging entries.

You can scroll forward and backward to view additional field names by pressing the F8 (FORward) and F7 (BACkward) keys. You can scroll forward 4000 lines, which corresponds to the maximum number of field names in Table A of a file.

If you specified a particular field name when you selected a Define or Redefine from the primary screen, FILEMGMT does not display this screen. Instead, FILEMGMT proceeds directly to the Field Attributes screen. For Rename and Delete, you must go to this screen first before proceeding to the Field Attributes screen.

When updates on this screen are saved, the fields are displayed in sorted order when the screen is reentered.

Field Name List screen input

FILEMGMT displays or prompts you for the following information:

Prompt Response
Filename FILEMGMT displays the name of the file that you entered on the primary screen.
Fieldname If you are creating a new file for which no fields have been defined, the Fieldname lines are blank.

If you are viewing an existing file and did not specify a particular field name on the primary screen, FILEMGMT lists all the fields in the file.

Follow these steps to stage fields for a particular function.

To define fields:

  1. If the field names are new, type in the names (1-70 characters). Use the standard Model 204 field naming conventions. If the field names already exist, type X to the left of the field names.

    You can remove field names that you just added to the Field Name List screen by typing D to the left of the newly entered names. Newly entered names display three asterisks (***) in the Cmd area if you press Enter.

  2. Press F11 (ATTributes).

    The Field Attributes screen displays the fields you selected in the order in which they are listed on the Field Name List screen. The fields are staged for DEFINE with default attributes.

To redefine fields:

  1. Select Redefine field from the main menu.
  2. Type X to the left of the field names to select them.
  3. Press F11 (ATTributes).

    The Field Attributes screen displays the fields you selected in the order in which they are listed on the Field Name List screen. The fields are staged for REDEFINE.

To delete fields:

  1. Select Delete field from the main menu.
  2. Type X to the left of the field names to select them.
  3. Press one of the following to stage the fields for DELETE:

    F2 (DOCument) F4 (FILe) F6 (COMmands) F9 (RECords) F11 (ATTributes) F12 (END) F3 (QUIt) to cancel the deletion

    Requesting a field deletion may generate a REDEFINE command for each record that the field cross-references. Each record's average length is decreased by the field's average length multiplied by the field percent rate for the record.

To rename fields:

  1. Select Rename Field from the main menu.
  2. Type over the existing names.
  3. Type X to the left of the field names to select them.
  4. Press one of the following to stage the fields for RENAME:

    F2 (DOCument) F4 (FILe) F6 (COMmands) F9 (RECords) F11 (ATTributes) F12 (END) F3 (QUIt) to cancel the operation

Cmd Displays the status of the field shown on the line.

If the field is currently staged, FILEMGMT displays the command that was generated for the field. The command is one of the following:

***Field name is new.
DEFField is being defined.
REDField is being redefined.
DELField is being deleted.
RENField is being renamed.
R/RField is being redefined and renamed.

Field operations might be staged if you begin to define, redefine, delete, or rename fields and then end your FILEMGMT session without executing the commands that were generated. When you begin a new session, these fields are shown as being staged.

If the field is not currently staged, this column is blank.

If a field name is added during a DEFINE operation and you press Enter, this column contains three asterisks (***).

A record's Cmd status determines whether you can issue a particular command for the record. The Command status table below summarizes your options (where an X indicates the command is valid for the record).

Command Status
Command New Staged as Existing
*** DEFINE REDEFINE DELETE RENAME
DEFINE X X X        
REDEFINE       X   X X
DELETE         X   X
RENAME       X   X X

Field Name List screen 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 Field Name List screen.
F2 DOCument Invokes the Dictionary/204 Documentation facility. Place the cursor over the field name that you want to document and press F2. Changes to the Field Name List screen are saved in the dictionary.
F3 QUIt Exits from the Field Name List screen and returns to the previous screen without making any changes.
F4 FILe Proceeds to the File Definition - Organization screen, if the file is new. Proceeds to the File Parameter Reset screen, if the file already exists. Changes to the Field Name List screen are saved in the dictionary.
F6 COMmands 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. Changes to the Field Name List screen are saved in the dictionary.
F7 BACkward Scrolls backward one screen. If you type BAC at the prompt (===>), followed by a number, FILEMGMT scrolls backward the specified number of lines.
F8 FORward Scrolls forward one screen. If you type FOR at the prompt (===>), followed by a number, FILEMGMT scrolls forward the specified number of lines.
F9 RECords Proceeds to the Record Name List screen. This screen lists the records in the file. Changes to the Field Name List screen are saved in the dictionary.
F11 ATTributes Proceeds to the Field Attribute screen. This screen defines attributes for the fields you just selected from the list. Changes to the Field Name List screen are saved in the dictionary.

When you return from the Field Attributes screen, the Xs you originally entered on the Field Name List screen:

  • Are removed from the prefix area of fields that were processed by pressing F11 (NEXtfld), or F12 (END) on the Field Attributes screen.
  • Remain in the prefix area of fields that were not processed.
F12 END Exits from the Field Name List screen and returns to the FILEMGMT primary screen. Changes to the Field Name List screen are saved in the dictionary.

Retaining field names when initializing the file

The File Initialize screen enables you to keep field definitions (using KEEPDEFS) when the file is initialized.

  1. Enter the file name on the primary screen.
  2. Select the INITIALIZE command.
  3. Press Enter.

The File Initialize screen is displayed:

FILEMGMT File Initialize Screen FILENAME: ABC Keep Field Definitions? N Inactive FICREATE: 6.1 FILEORG: Entry Order PAGESZ: 6184 ASIZE: 3 BSIZE: 15 DSIZE: 4 ESIZE: 0 PROCS ------------ ------------ ------------ ------------ ---------- ASTRPPG: 614 BRECPPG: 256 DRESERVE: 15 % EHIGHPG: CUR: 0 ATRPG: 1 BRESERVE: 17 PDSIZE: 1 EXP: 0 FVFPG: 1 RECS: 1000 PDSTRPPG: 128 AVPG: 1 MVFPG: 1 DPGSRES: 2 CSIZE: 1 FREESIZE: Total Space Pages: 5049 DDname Dataset Name ( 1 of 1 ) Device Trks/Blks ABC M204.ABC 3390 632 ===> FIM015 Use PF3 to cancel the DELETE Command or PF6/PF12 to process 1=HELp 2= 3=QUIt 4= 5= 6=COMmands 7= 8= 9= 10= 11= 12=END

The File Initialize screen duplicates the information on the File Size Definition screen.

The screen has only one input field: Keep Field Definitions?. N is the default. If you change it to Y, the INITIALIZE command is generated with the KEEPDEFS option which retains the field names when the file is initialized. After deciding whether to keep the field definitions, you can select one of the File Initialize commands in the following subsection.

File Initialize screen 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 Initialize screen.
F3 QUIt Exits from the File Initialize screen and returns to the primary screen without making any changes.
F6 COMmands Stages the file for INITIALIZE. 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.
F12 END Stages the file for INITIALIZE. Exits from the File Initialize screen and returns to the primary screen.