Adding record definitions with FILEMGMT: Difference between revisions

From m204wiki
Jump to navigation Jump to search
 
(45 intermediate revisions by 5 users not shown)
Line 1: Line 1:
==Record maintenance==
==Record maintenance==
<p>FILEMGMT provides you with an interface for performing all your record maintenance operations. This section describes how to perform the following operations:</p>
<p>
FILEMGMT provides you with an interface for performing all your record maintenance operations. This section describes how to perform the following operations:</p>
<ul>
<ul>
<li>List records in new and existing files.</li>
<li>List records in new and existing files.</li>
<li>Select the records you want to define, redefine, delete, and rename.</li>
<li>Select the records you want to define, redefine, delete, and rename.</li>
<li>Define and redefine records.</li>
<li>Define and redefine records.</li>
<li>Stage records in preparation for executing DEFINE, REDEFINE, DELETE, and RENAME commands. </li>
<li>Stage records in preparation for executing <var>DEFINE</var>, <var>REDEFINE</var>, <var>DELETE</var>, and <var>RENAME</var> commands. </li>
</ul>
</ul>
==Record Name List screen==
==Record Name List screen==
<p>To display the Record Name List screen, you can optionally:</p>
<p>
To display the Record Name List screen, you can optionally:</p>
<ul>
<ul>
<li>Press the PF4 (RECords) key from the Field Attributes screen. FILEMGMT displays the Record Name List screen in DEFINE mode.</li>
<li>Press the F4 (RECords) key from the Field Attributes screen. FILEMGMT displays the Record Name List screen in <var>DEFINE</var> mode.</li>
<li>Select a RECORD Maintenance function from the primary screen. FILEMGMT displays the Record Name List screen in the mode corresponding to the selected function. </li>
<li>Select a <b>Record</b> maintenance function from the primary screen. FILEMGMT displays the Record Name List screen in the mode corresponding to the selected function. </li>
</ul>
</ul>
<p>You use the Record Name List screen to:</p>
<p>
You use the Record Name List screen to:</p>
<ul>
<ul>
<li>Specify the names and frequency of the records in a file you are creating. A record name represents a record type.</li>
<li>Specify the names and frequency of the records in a file you are creating. A record name represents a record type.</li>
<li>View records in an existing file, define additional records, and select records you want to redefine, delete, or rename. </li>
<li>View records in an existing file, define additional records, and select records you want to redefine, delete, or rename. </li>
</ul>
</ul>
<p>If you are defining new records for a new or existing file, FILEMGMT displays the Record Name List screen in DEFINE mode:</p>
<p>
If you are defining new records for a new or existing file, FILEMGMT displays the Record Name List screen in <var>DEFINE</var> mode:</p>
<p class="caption" style="margin-right:20em">Record Name List screen in DEFINE mode</p>
<table>
<table>
<tr>
<tr>
<td>
<td>
<p class="code">FILEMGMT                             Record Name List                         Line 1 of 11
<p class="code">FILEMGMT                     Record Name List                     Line 1 of 11
Enter and Select with an 'X' those records you want to DEFINE
Filename: PERSONNL
    |                  | No. of  | Expected        | Occurrence |
    | Recordname        | Records  | Increase (%)    | in File    | Cmd
<b></b>---------------------------------------------------------------------------
X PERSONNL            | ________ | _______ | 100.0% | ***
_ ____________________ | ________ | _______ |        |
_ ____________________ | ________ | _______ |        |
_ ____________________ | ________ | _______ |        |
_ ____________________ | ________ | _______ |        |
_ ____________________ | ________ | _______ |        |
_ ____________________ | ________ | _______ |        |
_ ____________________ | ________ | _______ |        |
_ ____________________ | ________ | _______ |        |
_ ____________________ | ________ | _______ |        |
_ ____________________ | ________ | _______ |        |
_ ____________________ | ________ | _______ |        |


 
Enter and select with an 'X' the records you want to DEFINE to the file
 
Filename: PERSONNL
  ===>
  |                    | No. of  | Expected    | Occurrence |
 
  | Recordname          | Records | Increase (%) | in File    | Cmd
  1=HELp  2=DOCument    3=QUIt  4=FIElds  5=WIDen     6=COMmands
<b></b>--------------------------------------------------------------------
  7=      8=FORward     9=SIZe  10=       11=RECdefn  12=END
X PERSONNL              | ________ |    ___      |  100.0%    | ***
_ ____________________  | ________ |    ___      |            |
_ ____________________  | ________ |    ___      |            |
_ ____________________  | ________ |    ___      |            |
_ ____________________  | ________ |    ___      |            |
_ ____________________  | ________ |    ___      |            |
_ ____________________  | ________ |    ___      |            |
_ ____________________  | ________ |    ___      |            |
_ ____________________  | ________ |    ___      |            |
_ ____________________ | ________ |    ___      |            |
_ ____________________  | ________ |     ___      |            |
_ ____________________ | ________ |     ___      |            |
===>
   
   
</p></td>
1=HELp  2=DOCument    3=QUIt  4=FIElds  5=WIDen    6=COMmands
7=      8=FORward    9=SIZe  10=        11=RECdefn  12=END
</p>
</td>
</tr>
</tr>
</table>
</table>
<p>&nbsp;</p>
<p>
<p>The above record name list has an entry for a record name with the same name as the file. FILEMGMT creates this entry automatically.</p>
The above record name list has an entry for a record name with the same name as the file. FILEMGMT creates this entry automatically.</p>
<p>You can perform these operations:</p>
<p>
You can perform these operations:</p>
<ul>
<ul>
<li>Rename the entry by typing over the displayed name.</li>
<li>Rename the entry by typing over the displayed name.</li>
<li>Type additional record names, one record per line.</li>
<li>Type additional record names, one record per line.</li>
<li>Specify for each record name the number of records and expected increase to the number of records. ("No. of Records" is required input.)</li>
<li>Specify for each record name the number of records and expected increase to the number of records. (<b>No. of Records</b> is required input.)</li>
<li>Proceed to the Record Definition screen to define the contents of the new entries.</li>
<li>Proceed to the Record Definition screen to define the contents of the new entries.</li>
</ul>
</ul>
<p>If you are redefining, deleting, or renaming records, FILEMGMT displays the Record Name List screen in the mode corresponding to your requested function.</p>
<p>
<p>The following screen was invoked by selecting the REDEFINE function:</p>
If you are redefining, deleting, or renaming records, FILEMGMT displays the Record Name List screen in the mode corresponding to your requested function.</p>
<p>
The following screen was invoked by selecting <b>Redefine</b> for <b>Record</b> on the primary screen:</p>
<p class="caption" style="margin-right:20em">Record Name List screen in REDEFINE mode</p>
<table>
<table>
<tr>
<tr>
<td>
<td>
<p class="code">FILEMGMT                               Record Name List                         Line 1 of 2
<p class="code">FILEMGMT                     Record Name List                     Line 1 of 2
Select the records you want to REDEFINE with an 'X'
 
Filename: PERSONNL
Select the records you want to REDEFINE with an 'X'
    |                 | No. of  | Expected     | Occurrence |
Filename: PERSONNL
    | Recordname     | Records  | Increase (%) | in File    | Cmd
  |                     | No. of  | Expected     | Occurrence |
<b></b>----------------------------------------------------------------------------
  |   Recordname       | Records  | Increase (%) | in File    | Cmd
  _ EMPLOYEE           | _1000___ | _______ |  29.4% | ***
<b></b>--------------------------------------------------------------------
  _ DEPENDENTS________ | _2000___ | __20___ |  70.6% |
_ EMPLOYEE             | 1000    |     ___      |  29.4%     | ***
_ DEPENDENTS          | 2000    |     20      |  70.6%     |
                        |          |              |            |
                        |          |              |            | 
                        |          |              |            | 
                        |          |              |            | 
                        |          |              |            | 
                        |          |              |            | 
                        |         |              |            | 
                        |          |              |            | 
                        |          |              |            | 
===>
   
   
===>
1=HELp  2=DOCument    3=QUIt  4=FIElds  5=WIDen      6=COMmands
1=HELp  2=DOCument    3=QUIt  4=FIElds  5=WIDen      6=COMmands
7=      8=            9=SIZe  10=        11=RECdefn  12=END
7=      8=            9=SIZe  10=        11=RECdefn  12=END
Line 93: Line 103:
</tr>
</tr>
</table>
</table>
<p>If you specified a particular record name on the primary screen, FILEMGMT displays an X in the prefix area of this record.</p>
<p>
<p>Staged records display the command for which they are staged in the Cmd column. Nonstaged records have a blank in the Cmd column, as in the above screen. Staging is discussed in [[ FILEMGMT Overview#Staging entries|Staging entries]].</p>
If you specified a particular record name on the primary screen, FILEMGMT displays an <code>X</code> in the prefix area of this record.</p>
<p>You can scroll forward and backward to view additional record names by pressing the PF8 (FORward) and PF7 (BACkward) keys. You can scroll forward 100 lines, which corresponds to FILEMGMT's record number limit.</p>
<p>
Staged records display the command for which they are staged in the <b>Cmd</b> column. Nonstaged records have a blank in the <b>Cmd</b> column, as in the above screen. Staging is discussed in [[FILEMGMT overview#Staging entries|Staging entries]].</p>
<p>
You can scroll forward and backward to view additional record names by pressing the F8 (FORward) and F7 (BACkward) keys. You can scroll forward 100 lines, which corresponds to FILEMGMT's record number limit.</p>
====Record Name List screen input====
====Record Name List screen input====
<p>FILEMGMT displays or prompts you for the following information:</p>
<p>
<table>
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>Recordname </td>
<th>Recordname </th>
<td>
<p>If you are creating a new file, FILEMGMT displays a single record name that is the same as the file name.</p>
<p>If you are viewing an existing file and did not specify a particular record name on the primary screen, FILEMGMT lists all the records in the file.</p>
<p>Follow these steps to stage records for a particular function. </p>
<p>To DEFINE records: </p>
<b>Enter the record names in the "Recordname" column.</b>
<p>To enter new record names, type in the names (1-70 characters). Use the standard <var class="product">Model&nbsp;204</var> record naming conventions described in the Rocket <var class="product">Model&nbsp;204</var> File Manager's Guide. </p>
<p>To enter new records for an existing file, type the names at the bottom of the list. To enter a record name that is longer than the space provided (20 characters), position the cursor on the record name. Press the PF5 (WIDen) key to advance to the Widen screen. </p>
<p>You can remove new names before you end the session. Type a D in the prefix area to the left of the new name. The deletion removes a line from the display, but does not affect the physical data. </p>
<ol>
<li>Type X to the left of the record names to select them. </li>
<li>Press PF11 (RECdefn). </li>
</ol>
<p>The Record Definition screen displays the records you selected in the order in which they are listed on the Record Name List screen. The records are staged for DEFINE. </p>
<p>To REDEFINE records: </p>
<b>On the main menu, using the record option, select option 2.</b>
<b>Type X to the left of the record names to select them.</b>
<ol>
<li>Press PF11 (RECdefn). The Record Definition screen displays the records you selected in the order in which they are listed on the Record Name List screen. The records are staged for REDEFINE. </li>
</ol>
<p>To DELETE records: </p>
<b>On the main menu, using the record option, select option 3.</b>
<b>Type X to the left of the record names to select them.</b>
<ol>
<li>Press one of the following to stage the records for DELETE:</li>
</ol>
<p>PF2 (DOCument)
PF4 (FIElds)
PF6 (COMmands)
PF9 (SIZe)
PF11 (RECdefn)
PF12 (END) </p>
<ol>
<li>Press PF3 (QUIt) to cancel the deletion. </li>
</ol>
<p>To RENAME records: </p>
<b>On the main menu, using the record option, select option 4.</b>
<b>Type X to the left of the record names to select them.</b>
<ol>
<li>Type over the existing names. Press the PF5 (WIDen) key to enter a name that has more than 20 characters.</li>
</ol>
<p>&nbsp;</p>
</td>
</tr>
<tr>
<td>Recordname (continued)</td>
<td>
<td>
<ol>
<p>
<li> Press one of the following to stage the records for RENAME:</li>
If you are creating a new file, FILEMGMT displays a single record name that is the same as the file name.</p>
</ol>
<p>
<p>PF2 (DOCument)
If you are viewing an existing file and did not specify a particular record name on the primary screen, FILEMGMT lists all the records in the file.</p>
PF4 (FIElds)
PF6 (COMmands)
PF9 (SIZe)
PF11 (RECdefn)
PF12 (END) </p>
<p>Press PF3 (QUIt) to cancel the operation. </p>
</td>
</tr>
</tr>
<tr>
<tr>
<td>Cmd   </td>
<th>Cmd</th>
<td>
<td>
<p>Displays the status of the record shown on the line:</p>
<p>
Displays the status of the record shown on the line:</p>
<ul>
<ul>
<li>If the record is currently staged (in the process of being changed), FILEMGMT displays the command that was generated for the record. The command is one of the following:</li>
<li>If the record is currently staged (in the process of being changed), FILEMGMT displays the command that was generated for the record. The command is one of the following:
<table class="thJustBold">
<tr><th>***</th><td>Record name is new.</td></tr>
<tr><th>DEF</th><td>Record is being defined.</td></tr>
<tr><th>RED</th><td>Record is being read.</td></tr>
<tr><th>DEL</th><td>Record is being deleted.</td></tr>
<tr><th>REN</th><td>Record is being renamed. </td></tr>
<tr><th>R/R</th><td>Record is being redefined and renamed. </td></tr>
</table>
<p>
Record operations might be staged if you begin to define, redefine, delete, or rename records and then end your FILEMGMT session without executing the commands that were generated. When you begin a new session, these records are shown as being staged.</p>
</li>
<li>If the record is not currently staged, this column is blank. </li>
<li>If a record name is added during a <var>DEFINE</var> operation and you press Enter, this column contains asterisks (<tt>***</tt>).  </li>
</ul>
</ul>
<p>*** Record name is new.</p>
<p>
<p>DEF Record is being defined.</p>
A record's <b>Cmd</b> status determines whether you can issue a particular command for the record. [[#Command status|Command status]], below, is a table that summarizes your options (where an <code>X</code> indicates the command is valid for the record).</p>
<p>RED Record is being read.</p>
</td>
<p>DEL Record is being deleted. </p>
<p>REN Record is being renamed. </p>
<tr>
<p>R/R Record is being redefined and renamed. </p>
<th>No. of Records </th>
<p>Record operations might be staged if you begin to define, redefine, delete, or rename records and then end your FILEMGMT session without executing the commands that were generated. When you begin a new session, these records are shown as being staged.</p>
<td>Type the number of records of the specified record name to be stored in the file. For a new file, the number represents the initial number of records. Valid values are:
<ul>
<ul>
<li>If the record is not currently staged, this column is blank. </li>
<li>1-16777216 for non-RDFS files </li>
<li>If a record name is added during a DEFINE operation and you press Enter, this column contains ***.  </li>
<li>1-98304 for RDFS files</li>
</ul>
</ul>
<p>A record's Cmd status determines whether you can issue a particular command for the record. The following table summarizes your options; an X indicates the command is valid for the record.</p>
</td>
</td>
</tr>
<tr>
<th nowrap>Expected Increase (%)</th>
<td>Type the expected percentage of increase (0-100) in the number of records of the specified record name. The number represents the expected increase during the life of the file. If you do not enter a number in this column, FILEMGMT uses only <b>No. of Records</b> to calculate the size of the file. </td>
</tr>
<tr>
<th>Occurrence in File </th>
<td>FILEMGMT computes this value from <b>No. of Records</b> and <b>Expected Increase</b>, and it displays the value.</td>
</tr>
</tr>
</table>
</table>
===Record operations===
<p>
Follow these steps to stage records for a particular function. </p>
====Defining records====
<p>
To <var>DEFINE</var> records: </p>
<ol>
<li>Enter the record names in the <b>Recordname</b> column.
<p>
To enter new record names, type in the names (1-70 characters). Use the standard <var class="product">Model&nbsp;204</var> naming conventions. </p>
<p>
To enter new records for an existing file, type the names at the bottom of the list. To enter a record name that is longer than the space provided (20 characters), position the cursor on the record name. Press the F5 (WIDen) key to advance to the Widen screen. </p>
<p>
You can remove new names before you end the session. Type a <code>D</code> in the prefix area to the left of the new name. The deletion removes a line from the display, but does not affect the physical data. </p>
</li>
<li>Type <code>X</code> to the left of the record names to select them. </li>
<li>Press F11 (RECdefn).
<p>
The Record Definition screen displays the records you selected in the order in which they are listed on the Record Name List screen. The records are staged for <var>DEFINE</var>. </p>
</ol>
====Redefining records====
<p>
To <var>REDEFINE</var> records: </p>
<ol>
<li>On the main menu, using the record option, select option 2.
<li>Type <code>X</code> to the left of the record names to select them.
<li>Press F11 (RECdefn).
<p>
The Record Definition screen displays the records you selected in the order in which they are listed on the Record Name List screen. The records are staged for <var>REDEFINE</var>.</p> </li>
</ol>
====Deleting records====
<p>
To <var>DELETE</var> records: </p>
<ol>
<li>On the main menu, using the record option, select option 3.</li>
<li>Type <code>X</code> to the left of the record names to select them.</li>
<li>Press one of the following to stage the records for <var>DELETE</var>:
<p class="code">F2 (DOCument)
F4 (FIElds)
F6 (COMmands)
F9 (SIZe)
F11 (RECdefn)
F12 (END) </p>
<p>
Press F3 (QUIt) to cancel the deletion.</p></li>
</ol>
====Renaming records====
<p>
To <var>RENAME</var> records: </p>
<ol>
<li>On the main menu, using the record option, select option 4. </li>
<li>Type <code>X</code> to the left of the record names to select them. </li>
<li>Type over the existing names. Press the F5 (WIDen) key to enter a name that has more than 20 characters.</li>
<li> Press one of the following to stage the records for <var>RENAME</var>:
<p class="code">F2 (DOCument)
F4 (FIElds)
F6 (COMmands)
F9 (SIZe)
F11 (RECdefn)
F12 (END) </p>
<p>
Press F3 (QUIt) to cancel the operation. </p></li>
</ol>
===Command status===
<table>
<table>
<tr class="head">
<tr class="head">
<th colspan="8">Command Status</th>
<th colspan="8">Command Status</th>
</tr>
</tr>
<tr>
<tr class="head">
<th rowspan="2">Command</th>
<th rowspan="2">Command</th>
<th rowspan="2">New</th>
<th rowspan="2">New</th>
Line 200: Line 270:
<th rowspan="2">Existing</th>
<th rowspan="2">Existing</th>
</tr>
</tr>
<tr>
<tr class="head">
<th>***</th>
<th>***</th>
<th>DEFINE</th>
<th>DEFINE</th>
Line 207: Line 278:
<th>RENAME</th>
<th>RENAME</th>
</tr>
</tr>
<tr>
<tr>
<td>DEFINE</td>
<td>DEFINE</td>
Line 217: Line 289:
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</tr>
<tr>
<tr>
<td>REDEFINE</td>
<td>REDEFINE</td>
Line 227: Line 300:
<td>X</td>
<td>X</td>
</tr>
</tr>
<tr>
<tr>
<td>DELETE</td>
<td>DELETE</td>
Line 237: Line 311:
<td>X</td>
<td>X</td>
</tr>
</tr>
<tr>
<tr>
<td>RENAME</td>
<td>RENAME</td>
Line 248: Line 323:
</tr>
</tr>
</table>
</table>
<p>&nbsp;</p>
<table>
<tr class="head">
<th>Prompt</th>
<th>Response</th>
</tr>
<tr>
<td>No. of Records </td>
<td>
<p>Type the number of records of the specified record name to be stored in the file. For a new file, the number represents the initial number of records. Valid values are: </p>
<ul>
<li>1-16777216 for non-RDFS files </li>
<li>1-98304 for RDFS files</li>
</ul>
</td>
</tr>
<tr>
<td>Expected Increase (%)</td>
<td>Type the expected percentage of increase (0-100) in the number of records of the specified record name. The number represents the expected increase during the life of the file. If you do not enter a number in this column, FILEMGMT uses only "No. of Records" to calculate the size of the file. </td>
</tr>
<tr>
<td>Occurrence in File </td>
<td>FILEMGMT computes this value from "No. of Records" and "Expected Increase," and displays the value.</td>
</tr>
</table>
 
====Record Name List screen commands====
====Record 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 an F (function) key or type a command name at the prompt (<b>===></b>) and press Enter. </p>
<table>
<table>
<tr class="head">
<tr class="head">
Line 282: Line 333:
<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 Record Name List screen. </td>
<td>Displays HELP text for the Record 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 record name that you want to document and press PF2. Changes to the Record Name List screen are saved in the dictionary.</td>
<td>Invokes the Dictionary/204 Documentation facility. Place the cursor over the record name that you want to document and press F2. Changes to the Record 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 Record Name List screen and returns to the previous screen without making any changes. </td>
<td>Exits from the Record 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>FIElds </td>
<td>FIElds </td>
<td>Proceeds to the Field Name List screen. This screen lists the fields in the file. Changes to the Record Name List screen are saved in the dictionary.  </td>
<td>Proceeds to the [[Defining fields with FILEMGMT|Field Name List screen]]. This screen lists the fields in the file. Changes to the Record Name List screen are saved in the dictionary.  </td>
</tr>
</tr>
<tr>
<tr>
<td>PF5 </td>
<td>F5 </td>
<td>WIDen </td>
<td>WIDen </td>
<td>Proceeds to the Widen screen. This screen allows you to expand the length of the record name on the Record Name List screen and press PF5.</td>
<td>Proceeds to the Widen screen. This screen allows you to expand the length of the record name on the Record Name List screen.</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 Record 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 Record 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 the 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 the number, FILEMGMT scrolls forward the specified number of lines. </td>
</tr>
</tr>
<tr>
<tr>
<td>PF9 </td>
<td>F9 </td>
<td>SIZe </td>
<td>SIZe </td>
<td>Proceeds to the File Size Definition screen. This screen displays information about the size of the file. Changes to the Record Name List screen are saved in the dictionary. </td>
<td>Proceeds to the [[Managing file and table size with FILEMGMT|File Size Definition screen]]. This screen displays information about the size of the file. Changes to the Record Name List screen are saved in the dictionary. </td>
</tr>
</tr>
<tr>
<tr>
<td>PF11 </td>
<td>F11 </td>
<td>RECdefn </td>
<td>RECdefn </td>
<td>
<td>Proceeds to the [[Defining_records_with_FILEMGMT#Record Definition screen|Record Definition screen]]. This screen defines the records you just selected from the list. Changes to the Record Name List screen are saved in the dictionary.  
<p>Proceeds to the Record Definition screen. This screen defines the records you just selected from the list. Changes to the Record Name List screen are saved in the dictionary. </p>
<p>
<p>When you return from the Record Definition screen, the Xs you originally entered on the Record Name List screen are removed from the prefix area of records that were processed by pressing PF11 (NEXtrec), or PF12 (END) on the Record Definition screen. An X remains in the prefix area of records that were not processed. </p>
When you return from the Record Definition screen, the <code>X</code>s you originally entered on the Record Name List screen are removed from the prefix area of records that were processed by pressing F11 (NEXtrec), or F12 (END) on the Record Definition screen. An X remains in the prefix area of records that were not processed. </p>
</td>
</td>
</tr>
</tr>
<tr>
<tr>
<td>PF12 </td>
<td>F12 </td>
<td>END </td>
<td>END </td>
<td>Exits from the Record Name List Screen and returns to the primary screen. Changes to the Record Name List screen are saved in the dictionary.</td>
<td>Exits from the Record Name List Screen and returns to the primary screen. Changes to the Record Name List screen are saved in the dictionary.</td>
</tr>
</tr>
</table>
</table>
===Copying records===
===Copying records===
<p>Select the Copy Records function (number 5) from the primary screen. FILEMGMT displays the appropriate Copy screen.</p>
<p>
<p>You use the Copy screen to copy one or more records. The Copy can be to the same file (if just one record is copied) or to a different file. The records can be either existing or staged.</p>
Select the <b>Copy</b> function (number 5) for <b>Record</b> from the primary screen. FILEMGMT displays the appropriate Copy screen.</p>
<p>A Copy operation is performed as soon as you leave the Copy screen. The copied records are staged for the DEFINE command.</p>
<p>
<p>The cursor is initially positioned at the Record Name prompt.</p>
You use the Copy screen to copy one or more records. The Copy can be to the same file (if just one record is copied) or to a different file. The records can be either existing or staged.</p>
<p>
A Copy operation is performed as soon as you leave the Copy screen. The copied records are staged for the <var>DEFINE</var> command.</p>
<p>
The cursor is initially positioned at the <b>Recordname</b> prompt.</p>
====Copy screen input====
====Copy screen input====
<p>FILEMGMT displays or prompts you for the following information. </p>
<p>
<table>
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, 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>Record Name</td>
<th>Recordname</th>
<td>
<td>FILEMGMT displays the name of the record you entered on the primary screen. If you did not enter a name on the primary screen, FILEMGMT displays:  
<p>FILEMGMT displays the name of the record you entered on the primary screen. If you did not enter a name on the primary screen, FILEMGMT displays: </p>
<p class="code"><b></b>** All Records **
<p class="code"><b></b>** All Records **
</p></td>
</p></td>
</tr>
</tr>
<tr>
<tr>
<td>Copy to FILE </td>
<th>Copy to FILE</th>
<td>Type the name of the existing file to which FILEMGMT is to copy the record(s). This file can be the same as the file from which the copy is made, if you are not copying all records.</td>
<td>Type the name of the existing file to which FILEMGMT is to copy the record(s). This file can be the same as the file from which the copy is made, if you are not copying all records.</td>
</tr>
</tr>
<tr>
<tr>
<td>New Fieldname or record on the primary screen:</td>
<td><b>New Fieldname</b> or <b>New Recordname</b>:</td>
<td>
<td>If you entered a new record name for <b>Field, Record or Field Group Name</b> on the primary screen:
<p>If you entered a name for the New Recordname:</p>
<b>Type the name of the new record to which FILEMGMT is to copy the source record. The record name cannot already exist.</b>
<ol>
<ol>
<li>Press PF12 (END). FILEMGMT copies the record. </li>
<li>Type the name of the new record to which FILEMGMT is to copy the source record. The record name cannot already exist.
<li>Press F12 (END). FILEMGMT copies the record. </li>
</ol>
</ol>
<p>If you did not enter a name for the source record on the primary screen, FILEMGMT displays the following message:</p>
<p>
If you did not enter a name for the source record on the primary screen, FILEMGMT displays the following message:</p>
<p class="code"><b></b>** All Records **
<p class="code"><b></b>** All Records **
</p>
</p>
<p>Do the following:</p>
<p>
<b>Do not type a new record name.</b>
Do the following:</p>
<ol>
<ol>
<li>Press PF12 (END). FILEMGMT copies all records from one file to another. The copied records have the same names as the original records, but are prefixed (qualified) by the "Copy to FILE" name.</li>
<li>Do not type a new record name.</li>
<li>Press F12 (END). FILEMGMT copies all records from one file to another. The copied records have the same names as the original records, but are prefixed (qualified) by the <b>Copy to FILE</b> name.</li>
</ol>
</ol>
</td>
</td>
</tr>
</tr>
</table>
</table>
<b>Note</b>
<blockquote class="note"><b>Note:</b> A record is not copied to the target file if the file already contains a record with an unqualified name (name without the file name prefix) that is the same as the record name in the source file. FILEMGMT displays a <code>WARNING</code> message when it copies all records and finds entries with duplicate unqualified names. The warning messge indicates the number of records that can be copied. </blockquote>
<p>A record is not copied to the target file if the file already contains a record with an unqualified name (name without the file name prefix) that is the same as the record name in the source file. FILEMGMT displays a WARNING MESSAGE when it copies all records and finds entries with duplicate unqualified names. The WARNING MESSAGE indicates the number of records that can be copied. </p>
<p>&nbsp;</p>


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

Latest revision as of 21:32, 13 May 2014

Record maintenance

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

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

Record Name List screen

To display the Record Name List screen, you can optionally:

  • Press the F4 (RECords) key from the Field Attributes screen. FILEMGMT displays the Record Name List screen in DEFINE mode.
  • Select a Record maintenance function from the primary screen. FILEMGMT displays the Record Name List screen in the mode corresponding to the selected function.

You use the Record Name List screen to:

  • Specify the names and frequency of the records in a file you are creating. A record name represents a record type.
  • View records in an existing file, define additional records, and select records you want to redefine, delete, or rename.

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

Record Name List screen in DEFINE mode

FILEMGMT Record Name List Line 1 of 11 Enter and select with an 'X' the records you want to DEFINE to the file Filename: PERSONNL | | No. of | Expected | Occurrence | | Recordname | Records | Increase (%) | in File | Cmd -------------------------------------------------------------------- X PERSONNL | ________ | ___ | 100.0% | *** _ ____________________ | ________ | ___ | | _ ____________________ | ________ | ___ | | _ ____________________ | ________ | ___ | | _ ____________________ | ________ | ___ | | _ ____________________ | ________ | ___ | | _ ____________________ | ________ | ___ | | _ ____________________ | ________ | ___ | | _ ____________________ | ________ | ___ | | _ ____________________ | ________ | ___ | | _ ____________________ | ________ | ___ | | _ ____________________ | ________ | ___ | | ===> 1=HELp 2=DOCument 3=QUIt 4=FIElds 5=WIDen 6=COMmands 7= 8=FORward 9=SIZe 10= 11=RECdefn 12=END

The above record name list has an entry for a record name with the same name as the file. FILEMGMT creates this entry automatically.

You can perform these operations:

  • Rename the entry by typing over the displayed name.
  • Type additional record names, one record per line.
  • Specify for each record name the number of records and expected increase to the number of records. (No. of Records is required input.)
  • Proceed to the Record Definition screen to define the contents of the new entries.

If you are redefining, deleting, or renaming records, FILEMGMT displays the Record Name List screen in the mode corresponding to your requested function.

The following screen was invoked by selecting Redefine for Record on the primary screen:

Record Name List screen in REDEFINE mode

FILEMGMT Record Name List Line 1 of 2 Select the records you want to REDEFINE with an 'X' Filename: PERSONNL | | No. of | Expected | Occurrence | | Recordname | Records | Increase (%) | in File | Cmd -------------------------------------------------------------------- _ EMPLOYEE | 1000 | ___ | 29.4% | *** _ DEPENDENTS | 2000 | 20 | 70.6% | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | ===> 1=HELp 2=DOCument 3=QUIt 4=FIElds 5=WIDen 6=COMmands 7= 8= 9=SIZe 10= 11=RECdefn 12=END

If you specified a particular record name on the primary screen, FILEMGMT displays an X in the prefix area of this record.

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

You can scroll forward and backward to view additional record names by pressing the F8 (FORward) and F7 (BACkward) keys. You can scroll forward 100 lines, which corresponds to FILEMGMT's record number limit.

Record 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.
Recordname

If you are creating a new file, FILEMGMT displays a single record name that is the same as the file name.

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

Cmd

Displays the status of the record shown on the line:

  • If the record is currently staged (in the process of being changed), FILEMGMT displays the command that was generated for the record. The command is one of the following:
    ***Record name is new.
    DEFRecord is being defined.
    REDRecord is being read.
    DELRecord is being deleted.
    RENRecord is being renamed.
    R/RRecord is being redefined and renamed.

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

  • If the record is not currently staged, this column is blank.
  • If a record name is added during a DEFINE operation and you press Enter, this column contains asterisks (***).

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

No. of Records Type the number of records of the specified record name to be stored in the file. For a new file, the number represents the initial number of records. Valid values are:
  • 1-16777216 for non-RDFS files
  • 1-98304 for RDFS files
Expected Increase (%) Type the expected percentage of increase (0-100) in the number of records of the specified record name. The number represents the expected increase during the life of the file. If you do not enter a number in this column, FILEMGMT uses only No. of Records to calculate the size of the file.
Occurrence in File FILEMGMT computes this value from No. of Records and Expected Increase, and it displays the value.

Record operations

Follow these steps to stage records for a particular function.

Defining records

To DEFINE records:

  1. Enter the record names in the Recordname column.

    To enter new record names, type in the names (1-70 characters). Use the standard Model 204 naming conventions.

    To enter new records for an existing file, type the names at the bottom of the list. To enter a record name that is longer than the space provided (20 characters), position the cursor on the record name. Press the F5 (WIDen) key to advance to the Widen screen.

    You can remove new names before you end the session. Type a D in the prefix area to the left of the new name. The deletion removes a line from the display, but does not affect the physical data.

  2. Type X to the left of the record names to select them.
  3. Press F11 (RECdefn).

    The Record Definition screen displays the records you selected in the order in which they are listed on the Record Name List screen. The records are staged for DEFINE.

Redefining records

To REDEFINE records:

  1. On the main menu, using the record option, select option 2.
  2. Type X to the left of the record names to select them.
  3. Press F11 (RECdefn).

    The Record Definition screen displays the records you selected in the order in which they are listed on the Record Name List screen. The records are staged for REDEFINE.

Deleting records

To DELETE records:

  1. On the main menu, using the record option, select option 3.
  2. Type X to the left of the record names to select them.
  3. Press one of the following to stage the records for DELETE:

    F2 (DOCument) F4 (FIElds) F6 (COMmands) F9 (SIZe) F11 (RECdefn) F12 (END)

    Press F3 (QUIt) to cancel the deletion.

Renaming records

To RENAME records:

  1. On the main menu, using the record option, select option 4.
  2. Type X to the left of the record names to select them.
  3. Type over the existing names. Press the F5 (WIDen) key to enter a name that has more than 20 characters.
  4. Press one of the following to stage the records for RENAME:

    F2 (DOCument) F4 (FIElds) F6 (COMmands) F9 (SIZe) F11 (RECdefn) F12 (END)

    Press F3 (QUIt) to cancel the operation.

Command status

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

Record Name List screen commands

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

Key Command Meaning
F1 HELp Displays HELP text for the Record Name List screen.
F2 DOCument Invokes the Dictionary/204 Documentation facility. Place the cursor over the record name that you want to document and press F2. Changes to the Record Name List screen are saved in the dictionary.
F3 QUIt Exits from the Record Name List screen and returns to the previous screen without making any changes.
F4 FIElds Proceeds to the Field Name List screen. This screen lists the fields in the file. Changes to the Record Name List screen are saved in the dictionary.
F5 WIDen Proceeds to the Widen screen. This screen allows you to expand the length of the record name on the Record Name List screen.
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 Record 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 the number, FILEMGMT scrolls forward the specified number of lines.
F9 SIZe Proceeds to the File Size Definition screen. This screen displays information about the size of the file. Changes to the Record Name List screen are saved in the dictionary.
F11 RECdefn Proceeds to the Record Definition screen. This screen defines the records you just selected from the list. Changes to the Record Name List screen are saved in the dictionary.

When you return from the Record Definition screen, the Xs you originally entered on the Record Name List screen are removed from the prefix area of records that were processed by pressing F11 (NEXtrec), or F12 (END) on the Record Definition screen. An X remains in the prefix area of records that were not processed.

F12 END Exits from the Record Name List Screen and returns to the primary screen. Changes to the Record Name List screen are saved in the dictionary.

Copying records

Select the Copy function (number 5) for Record from the primary screen. FILEMGMT displays the appropriate Copy screen.

You use the Copy screen to copy one or more records. The Copy can be to the same file (if just one record is copied) or to a different file. The records can be either existing or staged.

A Copy operation is performed as soon as you leave the Copy screen. The copied records are staged for the DEFINE command.

The cursor is initially positioned at the Recordname prompt.

Copy 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, and indicates whether the file is Active or Inactive.
Recordname FILEMGMT displays the name of the record you entered on the primary screen. If you did not enter a name on the primary screen, FILEMGMT displays:

** All Records **

Copy to FILE Type the name of the existing file to which FILEMGMT is to copy the record(s). This file can be the same as the file from which the copy is made, if you are not copying all records.
New Fieldname or New Recordname: If you entered a new record name for Field, Record or Field Group Name on the primary screen:
  1. Type the name of the new record to which FILEMGMT is to copy the source record. The record name cannot already exist.
  2. Press F12 (END). FILEMGMT copies the record.

If you did not enter a name for the source record on the primary screen, FILEMGMT displays the following message:

** All Records **

Do the following:

  1. Do not type a new record name.
  2. Press F12 (END). FILEMGMT copies all records from one file to another. The copied records have the same names as the original records, but are prefixed (qualified) by the Copy to FILE name.

Note: A record is not copied to the target file if the file already contains a record with an unqualified name (name without the file name prefix) that is the same as the record name in the source file. FILEMGMT displays a WARNING message when it copies all records and finds entries with duplicate unqualified names. The warning messge indicates the number of records that can be copied.