FILEORG parameter: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
Line 31: Line 31:
Enables a number of enhancements to the file structure, including support for [[Field_Group_(File_Architecture)| physical field groups]]; the definition of up to 32000 fields in a file; system maintained [[Field_Design_(File_Management)#Automatic_Fields|Automatic fields]]; [[Field_Design_(File_Management)#Field_Constraints|Field Constraints]] providing content validation; and improved space management of fields containing [[Field_Design_(File_Management)#BLOB.2C_CLOB_and_MINLOBE_attributes|Large Objects]]. FILEORG=X'100' files cannot be accessed via FLOD or FILELOAD.
Enables a number of enhancements to the file structure, including support for [[Field_Group_(File_Architecture)| physical field groups]]; the definition of up to 32000 fields in a file; system maintained [[Field_Design_(File_Management)#Automatic_Fields|Automatic fields]]; [[Field_Design_(File_Management)#Field_Constraints|Field Constraints]] providing content validation; and improved space management of fields containing [[Field_Design_(File_Management)#BLOB.2C_CLOB_and_MINLOBE_attributes|Large Objects]]. FILEORG=X'100' files cannot be accessed via FLOD or FILELOAD.


If selected, the X'80' bit is automatically set.</td></tr>
If FILEORG=X'100' is selected, the X'80' bit is automatically set.</td></tr>
<tr><th align="right"><var>X'80'</var></th><td>Optimized Field Extraction Files : All nonpreallocated (non-OCCURS) fields are preceded by a field-value length byte. With a length byte on every field, even FLOAT, CODED or BINARY fields, several instructions and one IF test are eliminated from the internal field scan loop. Having a length byte also allows some simple compression of BINARY, CODED, and FLOAT values. Files created with FILEORG=X'80' cannot be opened in Model 204 version 6.1 or earlier.</td></tr>
<tr><th align="right"><var>X'80'</var></th><td>Optimized Field Extraction Files : All nonpreallocated (non-OCCURS) fields are preceded by a field-value length byte. With a length byte on every field, even FLOAT, CODED or BINARY fields, several instructions and one IF test are eliminated from the internal field scan loop. Having a length byte also allows some simple compression of BINARY, CODED, and FLOAT values. Files created with FILEORG=X'80' cannot be opened in Model 204 version 6.1 or earlier.</td></tr>
<tr><th align="right"><var>X'40'</var></th><td>File skewing enabled. (This option is obsolete and no longer recommended by Rocket. See the Rocket <var class="product">Model&nbsp;204</var> File Manager's Guide for a discussion of its history.)</td></tr>
<tr><th align="right"><var>X'40'</var></th><td>File skewing enabled. (This option is obsolete and no longer recommended by Rocket. See the Rocket <var class="product">Model&nbsp;204</var> File Manager's Guide for a discussion of its history.)</td></tr>

Revision as of 15:23, 10 September 2013

File organization

Summary

Default value
0
Parameter type
File
Where set
During file creation
Related products
All
Introduced
Model 204 V6.1 or earlier

Description

The file (Table B) organization

Valid settings of FILEORG are:

SettingMeaning
X'200' Large File Support

Available in Model 204 V7.5.

Allows files to hold up to 48 million records.

X'100' Enhanced Data Handling Files:

Available in Model 204 V7.5.

Enables a number of enhancements to the file structure, including support for physical field groups; the definition of up to 32000 fields in a file; system maintained Automatic fields; Field Constraints providing content validation; and improved space management of fields containing Large Objects. FILEORG=X'100' files cannot be accessed via FLOD or FILELOAD.

If FILEORG=X'100' is selected, the X'80' bit is automatically set.
X'80'Optimized Field Extraction Files : All nonpreallocated (non-OCCURS) fields are preceded by a field-value length byte. With a length byte on every field, even FLOAT, CODED or BINARY fields, several instructions and one IF test are eliminated from the internal field scan loop. Having a length byte also allows some simple compression of BINARY, CODED, and FLOAT values. Files created with FILEORG=X'80' cannot be opened in Model 204 version 6.1 or earlier.
X'40'File skewing enabled. (This option is obsolete and no longer recommended by Rocket. See the Rocket Model 204 File Manager's Guide for a discussion of its history.)
X'20'Unordered file.
X'08'Hash Key File.
X'04'Reuse record number (RRN). This option can be added to any other FILEORG option. If this option is set without the hash key (X'08') or sorted (X'01') options, the unordered option (X'20') is automatically set.

X'02'

Sort or hash key required in every record. (This option can be added to the X'08' and X'01' options.)
X'01'Sorted file.
X'00'Entry order file.