File creation overview: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
mNo edit summary
Line 2: Line 2:
<p>You can create a <var class="product">Model&nbsp;204</var> file in either of the following ways:</p>
<p>You can create a <var class="product">Model&nbsp;204</var> file in either of the following ways:</p>
<ul>
<ul>
<li>Using the Dictionary/204 File Management Subsystem Facility, FILEMGMT. (See [[ File management overview#Dictionary/204 File Management Subsystem facility|Dictionary/204 File Management Subsystem facility]] for an overview of FILEMGMT.)</li>
<li>Using FILEMGMT, the [[File management overview#Dictionary/204 File Management Subsystem facility|Dictionary/204 File Management Subsystem facility]]. </li>
<li>Entering the CREATE command on the command line or in a procedure that you create.</li>
 
<li>Manually, that is, entering the Model&nbsp;204 <var>CREATE</var> command on the command line or in a procedure that you create.</li>
</ul>
</ul>
<p>Of course, given the option to route the output of a FILEMGMT session to a sequential file or as procedure code, you can get the best of both worlds: for ease of use and to avoid errors, use FILEMGMT to generate the changes, but route and run them from a procedure so you have a history of the specific changes run, and so that the changes are reproducible (between a test and production environment, for example). </p>
<p>
<p>Regardless, the two methods described below are similar:</p>
Of course, given the option to route the output of a FILEMGMT session to a sequential file or as procedure code, you can get the best of both worlds: for ease of use and to avoid errors, use FILEMGMT to generate the changes. But route and run the changes from a procedure so you have a history of the specific changes run and so that the changes are reproducible (between a test and production environment, for example). </p>
====Notes====
<p>
Regardless, these two methods are similar. Their descriptions in the sections below contain the same seven operational steps but represent alternative ways of performing the operations. </p>
 
<blockquote class="note">
<p><b>Note:</b> </p>
<ul>
<ul>
<li>You cannot use FILEMGMT to create a file group or in-memory files (but you can route the output to a procedure, where the in-memory definition can be then set up).</li>
<li>You cannot use FILEMGMT to create a file group or in-memory files (but you can route the output to a procedure, where the in-memory definition can be then set up).</li>
<li>Dictionary/204 and its subsystems must use FILEMGMT.</li>
<li>Dictionary/204 and its subsystems must use FILEMGMT.</li>
</ul>
</ul>
<p>For details on the [[CREATE command: File|CREATE command]] syntax, see [[ Creating Files Manually#Creating Files Manually|Creating Files Manually]]. For details on using the File Management subsystem facility, see [[Creating a file with FILEMGMT]] .</p>
</blockquote>


==File creation process - with FILEMGMT==
==File creation using FILEMGMT==
<p>Adding a <var class="product">Model&nbsp;204</var> file to the database includes the following steps. Each step lists the alternative options of performing the operation manually and using the FILEMGMT interface.</p>
<p>
Adding a <var class="product">Model&nbsp;204</var> file to the database using the FILEMGMT interface includes the following steps. For details on using the File Management subsystem facility, see [[Creating a file with FILEMGMT]].</p>
<ol>
<ol>
<li>Define the file organization (FILEORG) and recovery (FRCVOPT) options using the File Definition - Organization screen.</li>
<li>Define the file organization (<var>FILEORG</var> parameter) and recovery (<var>FRCVOPT</var> parameter) options using the File Definition - Organization screen.</li>
<li>Define the file security by specifying the OPENCTL parameter values on the File Definition - Security screen.</li>
 
<li>Define the file security by specifying the <var>OPENCTL</var> parameter values on the File Definition - Security screen.</li>
 
<li>For procedure files, define the Table D procedure dictionary size requirements on the File Definition - Procedure screen.</li>
<li>For procedure files, define the Table D procedure dictionary size requirements on the File Definition - Procedure screen.</li>
<li>For data files, defining fields and their attributes:</li>
 
<li>For data files, define fields and their attributes:
<ul>
<ul>
<li>Define fields in FILEMGMT using the Field Name List and Field Attributes screens.</li>
<li>Define fields in FILEMGMT using the Field Name List and Field Attributes screens.</li>
</ul>
</ul></li>
 
<li>Size the file and its tables on the File Size Definition screen.</li>
<li>Size the file and its tables on the File Size Definition screen.</li>
<li>Run the <var>CREATE</var> command using the Execute Commands screen.</li>
<li>Do either of the following to initialize the file:
<ul>
<ul>
<li>Run the CREATE command using the Execute Commands screen.</li>
<li>Run the <var>INITIALIZE</var> command.</li>
</ul>
<li>Use the FILEMGMT Initialize File screen.</li>
<li>Initializing the file: </li>
<ul>
<li>Run the INITIALIZE command, OR</li>
<li>Initialize the file in FILEMGMT using the Initialize File screen.</li>
</ul>
</ul>
</ol>
</ol>
==File creation process - manual==
 
==Manual file creation==
<p>
<p>
Adding a <var class="product">Model&nbsp;204</var> file to the database includes the following steps (note that it is recommended that these steps be incorporated into a procedure so that the process can be easily run multiply times if some of the parameters require adjusting):</p>
Adding a <var class="product">Model&nbsp;204</var> file to the database includes the following steps (note that it is recommended that these steps be incorporated into a procedure so that the process can be easily run multiply times if some of the parameters require adjusting):</p>
<ol>
<ol>
<li>Define the file organization (<var>[[FILEORG parameter|FILEORG]]</var>) and recovery (<var>[[FRCVOPT parameter|FRCVOPT]]</var>) parameters for the <var>[[CREATE command: File|CREATE]]</var> command.</li>
<li>Define the file organization (<var>[[FILEORG parameter|FILEORG]]</var>) and recovery (<var>[[FRCVOPT parameter|FRCVOPT]]</var>) parameters for the <var>[[Creating a file#CREATE command|CREATE]]</var> command.</li>


<li>Define the file security with the <var>CREATE</var> command file security (<var>[[OPENCTL parameter|OPENCTL]]</var>) parameter.</li>
<li>Define the file security with the <var>CREATE</var> command file security (<var>[[OPENCTL parameter|OPENCTL]]</var>) parameter.</li>

Revision as of 19:35, 10 October 2014

To create a file, you must have superuser privileges.

You can create a Model 204 file in either of the following ways:

Of course, given the option to route the output of a FILEMGMT session to a sequential file or as procedure code, you can get the best of both worlds: for ease of use and to avoid errors, use FILEMGMT to generate the changes. But route and run the changes from a procedure so you have a history of the specific changes run and so that the changes are reproducible (between a test and production environment, for example).

Regardless, these two methods are similar. Their descriptions in the sections below contain the same seven operational steps but represent alternative ways of performing the operations.

Note:

  • You cannot use FILEMGMT to create a file group or in-memory files (but you can route the output to a procedure, where the in-memory definition can be then set up).
  • Dictionary/204 and its subsystems must use FILEMGMT.

File creation using FILEMGMT

Adding a Model 204 file to the database using the FILEMGMT interface includes the following steps. For details on using the File Management subsystem facility, see Creating a file with FILEMGMT.

  1. Define the file organization (FILEORG parameter) and recovery (FRCVOPT parameter) options using the File Definition - Organization screen.
  2. Define the file security by specifying the OPENCTL parameter values on the File Definition - Security screen.
  3. For procedure files, define the Table D procedure dictionary size requirements on the File Definition - Procedure screen.
  4. For data files, define fields and their attributes:
    • Define fields in FILEMGMT using the Field Name List and Field Attributes screens.
  5. Size the file and its tables on the File Size Definition screen.
  6. Run the CREATE command using the Execute Commands screen.
  7. Do either of the following to initialize the file:
    • Run the INITIALIZE command.
    • Use the FILEMGMT Initialize File screen.

Manual file creation

Adding a Model 204 file to the database includes the following steps (note that it is recommended that these steps be incorporated into a procedure so that the process can be easily run multiply times if some of the parameters require adjusting):

  1. Define the file organization (FILEORG) and recovery (FRCVOPT) parameters for the CREATE command.
  2. Define the file security with the CREATE command file security (OPENCTL) parameter.
  3. For procedure files, calculate the Table D procedure dictionary size as described in Sizing Table D.
  4. For data files, define the fields and their attributes using the DEFINE FIELD command.
  5. Size the file and its tables by calculate the table sizes manually as described in File size calculation .
  6. Run the CREATE command.
  7. Run the INITIALIZE command.