This panel displays all fields in the Field reference file (FRF) in the system, together with a possible reference field, a descriptive text, the field length, the number of digits and the number of decimals.
Options
| Promote | Select this option to access a panel where you can promote the field from one subset to another. |
| Used in files | Select this option to view in which display files, physical files and/or printer files the fields are used. |
| File texts | Select this option to view every field that refers to the Reference field in the FRF that has a text. |
Function keys
Selection fields
- Field name
- This column lists the field name.
- Subset
- This column lists the subset to which the field belongs.
- Text
- This column lists the description for the field.
- Field type
- This column lists the type code for the field.
Type Description A Alphanumeric field P Packed numeric field S Signed numeric field G Graphics. The field will be tagged with CCSID(1200) to support Unicode data. If Double Byte Character Set is installed on the iSeries, the following type codes may be used instead of A:
Type Description J Fields that can contain only DBCS data E Fields that can contain DBCS or alphanumeric data O Fields that can contain both DBCS and alphanumeric data
- Field length
- This column lists the length of the field.
- Number of digits
- This column lists the number of digits for numeric fields.
- Decimals
- This column lists the number of decimals for numeric fields.
- Referenced field
- This column lists the main field name as the reference field if the field is a sub-field to another field name, under which this field shall be listed.
- Identity
- This column lists the identity.
- PTF level
- This column lists the PTF level in which this field was added.
- Mod number
- This column lists the modification number.
Work with field reference fields (ASTD10104)
The entries make up the field reference files. Each field in the system has a unique four character code.
When fields have been added, changed or deleted, you should run the Create new FRF routine.
Note: Duplicate fields are not allowed within the same subset. For example, field ABCD may be defined for both subset *STANDARD and *COUNTRY but may not be defined for two different projects.
Function keys
| Free text | Access the field’s free text. |
- Field name
- This field is only used for new entries. Enter the four character code that is to represent the field you are adding to the file. Valid characters are A to Z and 1 to 9.
- Type
- Enter the type code for the field.
Type Description A Alphanumeric field P Packed numeric field S Signed numeric field G Graphics. The field will be tagged with CCSID(1200) to support Unicode data. If Double Byte Character Set is installed on the iSeries, the following type codes may be used instead of A:
Type Description J Fields that can contain only DBCS data E Fields that can contain DBCS or alphanumeric data O Fields that can contain both DBCS and alphanumeric data
- Length
- Enter the length of the field. This information must only be completed for alphanumeric fields. For numeric fields, the system will insert the field length automatically.
- No dig
- Enter the number of digits for the field. This information must only be completed for numeric fields.
- No dec
- Enter the number of decimals for the field. This information must only be completed for numeric fields.
- Edtcde
- Enter an edit code for this field. This information must only be completed for numeric fields.
- Ref sh
- Enter a reference shift for this field. The reference shift defines which characters that may be entered in the selected field on a maintenance panel. The following characters are valid for alphanumeric fields:
- N
- A
- X
- W
- I
- D
- M
The following characters are valid for numeric fields:
- S
- Y
- N
- I
- D
- Reference field
- If the field you are adding is a sub-field to another field name, under which this field shall be listed, you enter the main field name as reference field. The reference field must already exist in the FRF.
- Edit word
- Enter a format that consists of blanks and characters which is to apply to the selected field. For example, you can enter a format for the TIME field, which defines that the hour, minutes and seconds are to be separated by colons.
- Include field in FRF
- Not every field has to be part of the FRF. You may, e.g., want to create some text fields that you do not want to be part of the FRF. They will, however, still be displayed in the table. Set this field to NO if the field should NOT be part of the FRF.
- Text
- Column heading 1-3
- Column headings shall be entered for the field, and each heading shall, if possible, not be longer than the field length. The column headings are used when creating windows for the field, or when running a query for a file where the field is used.
- Abbreviation
- If you need to abbreviate a field name for, e.g., a column heading, enter the standard abbreviation which should be used in all files where the scenario takes place.
- Lead text
- Enter/displays the lead text for the field.
- Alias
- Enter a descriptive alias for the field name which is used as an identifier as the second field name. This mandatory entry, for Physical files only, must be unique within the FRF. It is retrieved in the Work with Database Definitions, Fields in File panel, as the Long field name.
- Subset
- Displays the name of the subset for an existing field. The field is mandatory when you add a new field.
- Identity
- Change date
- PTF/Mod number
- Changed by user
- Displays the user profile id of the last person who changed this field.
Work with field reference fields, Copy (ASTD10105)
From this panel you can copy a field to create a new.
- Field name
- Displays the FRF field name that you are working with.
- Subset
- Displays the subset for the record that you are copying.
- New field name
- Enter the name of the new FRF field.
- New subset
- Enter the subset in which the new field will be stored.
Work with field reference fields, Deletion (ASTD10108)
From this panel you can physically delete a FRF. Click OK to confirm the deletion.
Work with field reference fields, Promote (ASTD10111)
On this panel you promote the FRF, one subset at a time, to a higher level subset.
- Field name
- Displays the name of the FRF.
- Subset
- Displays the subset in which the FRF which you are promoting is stored.
- New subset
- Enter the new subset in which the new FRF will be stored.
Work with field reference fields, Used in file – DB files / Used in file – All files (ASTD10114)
On this panel you can view a list of the files where the field is used. To be able to view this information, the Retrieve FRF to file references routine must be run first.
Options
| Fields | This option is not available in enquiry mode. Select this option to view all fields in the file. |
| Crossref | Select this option to access the Program structure enquiry panel where you can view the File/Field cross references. |
Function keys
| Show all files / Show DB files | Toggle between viewing Database files only, and All files. |
| Print list | Order a printout of the records in this panel. |
- File name
- Displays the name of the file in which the field is used.
- Library
- Displays the library in which the file is stored.
- Description
- Displays the file description.
Work with field reference fields, More selections (ASTD10117)
More selections
- Field name
- Reference field
- Field type
- Field length
- Subset
- Identity
- Release
- Mod number