The database definition tool is geared to developers of DC1, providing an overview of the files (i.e. physical files, display file and printer files), that exist in the system. Upon entry into this program, only physical files are listed. To view the other types of files, click More selections to select that attribute.
The information in this program is used in the FRF program, allowing you to see in what file the field is used, as well as in the DC1 Corporate Data Maintenance application, allowing you to move files (send/receive data) between different companies in the same iSeries, environment and release.
In this program you work with all database-related functionality. This tool gives you flexibility and ease of use with:
- Database design
- Database development
- Terminology
- System documentation
- Database conversion
From one single starting point, you can (assuming you have sufficient authority):
- Add, change, copy, delete, print or promote physical file information
- View all automatically generated files with attribute DSPF and PRTF
- View all automatically generated connections between files and fields
- Drill down to field definitions, with the added possibility to add new fields
- Drill down to files using the reference field and view/maintain all information regarding the fields in those files (e.g., lead text, text, free text, column heading, etc).
- Drill across to CROSSREF
- Generate a printout of the system documentation outlining all the information for the file (e.g., every field, field text, FRF free text, conversion text, etc). This is extremely useful in combination with the More selections function. You can first narrow down the files that you have worked on during a development release, or for a PTF, and then print a list of just those files that have been changed.
All files in DC1 are categorised into subsets.
Options
| Fields | Select this option to access a panel where you can maintain the fields belonging to the object. |
| Promote | Select this option to access a panel where you can promote the object from one subset to another. Note: Promote is only valid for objects with attribute PF. |
| Select this option to access a panel where you can order a printout, outlining all information connected to the object, (i.e. fields, field texts, etc). | |
| Crossref | Select this option to access the Program structure enquiry panel where you can view the File/Field cross references. |
| LSTFFD | Select this option to access the List file field description panel. Note: This is only valid for objects with attribute PF. |
Function keys
Selection fields
Work with database definitions (ASTD19504)
On this panel you enter, change or view information for the object.
Function keys
| Free text | Access the Edit text panel, where you can add free text. |
- Object
- This field can only be completed for new entries. Enter the name of the object identifying the file you are adding.
- Object attribute
- Enter the attribute of the object. Attributes could be:
- PF = Physical file
- DSPF = Display file
- PRT = Printer file
- Object library
- Enter the library in which the object should be stored.
- Description
- Enter the description of the object.
- Status
- Enter the code for New, Update or Removed, identifying the status of the file.
- Field name prefix
- This field is optional and can be used to suggest a field name when adding new fields.
- Long file name
- Mandatory for Physical files only. This field is only allowed to be edited when it is blank. Enter/displays a unique, descriptive alternative for the file name.
- Business entity
- This field is optional and can be used to collect Physical files that relate to a specific business entity. This information can be used for analysis purposes of system documentation on a higher level.
Example: You want to be able to analyse all PF’s that relate to a sales order (be it on order header and/or line level). Enter a code from the Business entity table indicating the entity in DC1 to which this object belongs (e.g., items, names (customer/supplier), sales, assets, etc).
- Application
- Enter the application to which this object belongs.
- Database class
- This field is valid only for Physical files and is optional. Enter a code from the Database class table indicating the type of DC1 database file for this file.
- Preloaded
- Indicate if the file should be preloaded.
- Statistics included
- Indicate if the file includes statistical information, (e.g., balances or other statistics).
- External interface
- This field is preloaded with a YES setting for all Physical files that are supported in the DC1 Corporate Data Maintenance application within the Standard release of DC1. This means that you can transfer these files (send/receive data) between different companies, in the same iSeries, environment and release. For all other files, set this field to YES or NO indicating if you want the file to be supported within DC1 Corporate Data Maintenance.
- DI interface file
- This field is preloaded for all Physical files that are supported in the DC1 Corporate Data Maintenance application within the Standard Release of DC1 (i.e. the External interface field is set to YES). DI Interface files are an exact image of the physical file with an additional number of fields that are used when sending and receiving through the DI interface. In base DC1 the DI files are named according to a specific standard, e.g., SROPRG -> DIOPRG. If you are adding a new physical file to DC1 CDM, you must complete this field.
- Service program
- This field is preloaded for all Physical files that are supported in the DC1 Corporate Data Maintenance application within the Standard Release of DC1. If you are adding a new physical file to DC1 CDM and this file is to have an Object module created, the module should be included in a service program. Enter the name of the service program according to the applicable standards.
- Object module
- This field is preloaded for all Physical files that are supported in the DC1 Corporate Data Maintenance application within the Standard Release of DC1. If you are adding a new physical file to DC1 CDM, this is the name of the Object module that will be created/generated to hold logic for this file. Normally the name of the Object module should be the same as the file itself.
- Maintenance pgm
- Enter the name of the maintenance program for this file.
- Update pgm
- Enter the name of the update program for this file.
- Enquiry pgm
- Enter the name of the enquiry program for this file.
- Validation pgm
- Enter the name of the validation program for this file.
- Reorganisation pgm
- Enter the name of the reorganisation program for this file.
- Subset
- This field is defaulted to the release subset. Keep as is or change to the applicable subset for this file.
- Identity
- Change date
- Displays the date this file was last changed.
- PTF/Mod number
- Changed by user
- Displays the user profile id of the last person who changed this file.
Work with database definitions, Copy (ASTD19505)
On this panel you enter the new information for the copied object.
- Object
- Displays the name of the object you are copying.
- Attribute
- Displays the attribute of the object (i.e. PF, DSPF or PRTF).
- Subset
- Displays the subset to which the object you are copying belongs.
- New object
- Enter the name of the new object.
- New subset
- Enter the subset to which the new object should belong.
- New format
- Enter the record format for the new file. If nothing is entered, the old record format from the copied file will be used. This information is also displayed on field level. However, since it is not possible to change on field level, it is recommended that you set it before copying.
- New prefix
- Enter the field name prefix for the new file. If nothing is entered, the old field name prefix from the copied file will be used.
Work with database definitions, Deletion (ASTD19508)
From this panel you can physically delete an object. Click OK to confirm the deletion.
Work with database definitions, Promote (ASTD19511)
On this panel you promote the object, one subset at a time, to a higher level subset.
- Object
- Displays the name of the object.
- Attribute
- Displays the attribute of the object.
- Subset
- Displays the subset to which the object belongs.
- New subset
- Enter the name of the new subset to which you are promoting the object.
Work with database definitions, Print list (ASTD19514)
From this panel you can generate a printout of the system documentation outlining all the information for the file (e.g., every field, field text, FRF free text, conversion text, etc). This is extremely useful in combination with the More selections function. You can first narrow down the files that you have worked on during a development release, or for a PTF, and then print a list of just those files that have been changed.
- Object
- Displays the name of the object.
- Attribute
- Displays the attribute of the object.
- Description
- Displays the description of the object.
- Simple
- Indicate if you want to generate a simple list (i.e. which fields exist for the object).
- Complete
- Indicate if you want to generate a complete list, outlining all file attributes per field.
Work with database definitions, More selections (ASTD19517)
On this panel you can narrow down the records that you want to work with on the main Work with Database Definitions panel.
Selections
- Object
- Object attribute
- Application
- Database class
- Subset
- Identity
- Release
- Mod number
- Service program
- Business entity
- You can narrow down the selection by entering the Business entity to which the file belongs.
- Preloaded
- You can narrow down the selection by entering YES or NO, indicating that you want to include/exclude preloaded files.
- Statistics included
- You can narrow down the selection by entering YES or NO, indicating that you want to include/exclude those files which contain statistical information.
- External interface
- You can narrow down the selection by setting this field to YES or NO, indicating that you want to include/exclude those files that are supported within DC1 Corporate Data Maintenance.
- Status
- You can narrow down the selection by entering any one of the following valid status codes assigned to a file: New, Update, Removed.