Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | RECORD_FILE |
| Short Name | RFI |
| View Name | CI_RECORD_FILES |
| Description | A file containing records (eg a COBOL file) |
| Sub-type of | OS_FILE |
| Versioning: | Structure of RECORD_FILE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_FIL |
| Changes: | Summary of changes to RECORD_FILE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| ACCESS_METHOD | VARCHAR2(16) | Y | The most commonly used access method for accessing the records in a file e.g. indexed, ISAM.
Prompt: Access Method Uppercase | FIL_ACCESS_METHOD Non-enforced | |
| BLOCK_SIZE | NUMBER(10, 0) | Y | The size of each block in this file, expressed in the units held in the property UNIT
Prompt: Block Size Range: 0 to 9999999999 | ||
| CLUSTER_SIZE | NUMBER(10, 0) | Y | The size of each cluster, expressed in the units held in the property UNIT
Prompt: Cluster Size Range: 0 to 9999999999 | ||
| FILE_SIZE | NUMBER(10, 0) | Y | The file size e.g. number of bytes in a file.
Prompt: File Size Range: 0 to 9999999999 Defined on FIL supertype | ||
| FILE_TYPE | VARCHAR2(16) | Y | The type of file e.g. ASCII, BINARY.
Prompt: Type Uppercase Defined on FIL supertype | FIL_FILE_TYPE Non-enforced | |
| FULL_PATHNAME | VARCHAR2(240) | Y | Full pathname of file including extension (and node if appropriate). Optional but, if present, must be unique among OS_FILES
Prompt: Full Pathname Defined on FIL supertype | ||
| NAME | VARCHAR2(100) | N | The name of this file.
Prompt: Name Uppercase Defined on FIL supertype | ||
| ORGANIZATION | VARCHAR2(16) | Y | The organization of the file e.g. indexed, relative or sequential
Prompt: Organization Uppercase | FIL_ORGANIZATION Non-enforced | |
| OS_FILE_TYPE | VARCHAR2(3) | N | Sub-type discriminator. Internal property indicating whether the OS_FILE is a RECORD_FILE (RFI) or a SOURCE_FILE (SFI)
Not displayed Uppercase System maintained Not updatable by user Defined on FIL supertype | OS_FILE_TYPE | |
| REMARK | VARCHAR2(70) | Y | A brief comment about this file.
Prompt: Comment Defined on FIL supertype | ||
| STORAGE_MEDIA | VARCHAR2(16) | Y | The type of media used for storing this file.
Prompt: Storage Medium Uppercase | FIL_STORAGE_MEDIA Non-enforced | DISK |
| UNIT | VARCHAR2(10) | Y | The units for the size of the block, cluster or file e.g. byte, kilobyte.
Prompt: Unit Uppercase Defined on FIL supertype | FILEUNIT Non-enforced | BYTE |
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DESCRIPTION | CDIDSC Defined on FIL supertype |
Description |
| NOTES | CDINOT Defined on FIL supertype |
Notes |
| Other Properties |
|---|
| RECORD_FILE has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility |
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference RECORD_FILE:
Note: