Trail: PROIV Documentation > Administration > Environment Guide > Defining a Subfile

Defining a Subfile

To define a Subfile, follow these steps:

  1. Click down arrow next to the New icon Comment on this topic

    Topic ID: 720057

    ' ''; border-left-style: none; border-top-style: none; border-right-style: none; border-bottom-style: none; width: 30px; height: 22px; float: none; border-style: none; border-style: none;" width=30 height=22 border=0> on the PROIV Developer Toolbar and select the option. Alternatively select the Developer menu, select the New menu option and select the New File Definition option.

  2. The Name the new file definition window displays. This window enables you to create File Definitions.

  3. Enter the file name in the File Name field. This must match the Subfile type variable name in the Master File unless a Physical File is set.

  4. Enter a Description of the file in the Description field.

  5. Select the file type from the File Type drop-down list. The available options for Subfiles are SUBF and SUBF2.

  6. Select the appropriate security level for the File Definition from the Category drop-down list.

  7. Enter the name of the Physical File, where the data will be stored. The Physical File name must match the Subfile type variable name in the Master File. Physical Fie is optional, and if it is not set, the file name itself must match the Subfile type variable name.

  8. You can copy details from an existing File Definition by selecting the file from the File drop-down list in the Copy from File section. Select the appropriate option from the Copy As section.

  9. Click OK to create the File Definition.

  10. The Editing File Definition window appears. Enter the File Variables for the File Definition, for more information about the window, click here.

  11. Click icon on the File Definition Toolbar to open the Properties window for Subfile File Definition.

  12. Enter the following information for Subfiles:

Item

Description

Properties Tab

 

Description

Description of the Subfile.

File type

Select Subfile file type:

SUBF - Multiple values that are separated by value marks (ASCII code value 253), and optional subvalues are separated by subvalue marks (ASCII code value 252).

SUBF2 - Multiple values that are separated by value marks (ASCII code value 253), and optional subvalues are separated by subvalue marks (ASCII code value 92).

Physical File

The Physical File name must match the Subfile type variable name in the Master File. This is optional, and if it is not set, the file name itself must match.

Encryption Key

Not supported for Reality files.

Co/Div

Enter N (or leave blank).

Auto Seq

Enter Y or N (default). A Subfile definition can be autosequenced or non-autosequenced. An autosequenced Subfile definition must have exactly one K-type File Variable that is the sequence number and corresponds to the position of the subrecord (value) within the Subfile.  Using such a definition, duplicate subrecords can be created in a Subfile. (The key is not physically part of the subrecord.)

A non-autosequenced Subfile definition must have at least one K-type File Variable. The key corresponds to the first subvalue of a subrecord (value) in the Subfile. Using such a definition, the key must be unique for each subrecord in a Subfile.

Lock Sequence

Select the check box to enable Enforced Paging. Click here for more information about Enforced Paging.

Security

Specify the security level for the Subfile.

Metrics Tab

 

Creation Date

Displays the date when the Subfile File Definition was created.

Creation Time

Displays the time when the Subfile File Definition was created.

Key Length

Displays the key length of the Subfile File Definition.

Record Length

Displays the record length of the Subfile File Definition.

Messages

 

Record Missing

Enter the message to display when the record is missing. Select the Translate check box to set the message for translation when using the Multilingual functionality.

Record Present

Enter the message to display when the record is present. Select the Translate check box to set the message for translation when using the Multilingual functionality.

Record Locked - Retrying

Enter the message to display when the record locked and a retry is in process. Select the Translate check box to set the message for translation when using the Multilingual functionality.

Record Locked - Retry/Abort

Enter the message to display when the record locked and a retry/abort is required. Select the Translate check box to set the message for translation when using the Multilingual functionality.