File creation overview: Difference between revisions

From m204wiki
Jump to navigation Jump to search
Line 8: Line 8:
<p>Regardless, the two methods described below are similar:</p>
<p>Regardless, the two methods described below are similar:</p>
====Notes====
====Notes====
<p>&nbsp;</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>
Line 14: Line 13:
</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#Creating a File with FILEMGMT|Creating a File with FILEMGMT]] .</p>
<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#Creating a File with FILEMGMT|Creating a File with FILEMGMT]] .</p>
==File creation process - with FILEMGMT==
==File creation process - with 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 includes the following steps. Each step lists the alternative options of performing the operation manually and using the FILEMGMT interface.</p>

Revision as of 19:11, 12 December 2013

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 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).

Regardless, the two methods described below are similar:

Notes

  • 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.

For details on the CREATE command syntax, see Creating Files Manually. For details on using the File Management subsystem facility, see Creating a File with FILEMGMT .

File creation process - with FILEMGMT

Adding a Model 204 file to the database includes the following steps. Each step lists the alternative options of performing the operation manually and using the FILEMGMT interface.

  1. Define the file organization (FILEORG) and recovery (FRCVOPT) 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, defining 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.
    • Run the CREATE command using the Execute Commands screen.
  6. Initializing the file:
    • Run the INITIALIZE command, OR
    • Initialize the file in FILEMGMT using the Initialize File screen.

File creation process - manual

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.