File Groups overview

File Groups can be created in order to associate a series of files with each other for reporting purposes. For example, the Marketing Department may be interested in records that are in the Customer Master file and in the Customer Order file. It may make reporting against these files easier when viewed together.

Additionally, file groups can be used to limit access of users to data in their appropriate functional areas. Once a set of files has been identified, they can be grouped together. The name of the group can then be associated with the user in User & Security Maintenance function. All inquiries and reports will then "hide" archived data changes of files outside the group.

Adding a new File Group

You can add a file group in order to establish the name or category for the files that you would like to treat as a related set of files for reporting purposes. This is done through Database Monitor File Groups Maintenance IDT101-01.

To add a new file group

From any Database Monitor menu, enter option 14 or 24 to open the Database Monitor File Groups Maintenance panel.
Press F6. The Add New Record panel appears.
Enter the Group Name, Description, and specify whether this group should be secure, then press Enter.

Changing a File Group

You can make changes to a file group's description and its security status through IDT101-01.

To change a file group

From any Database Monitor menu, enter option 14 or 24 to open the Database Monitor File Groups Maintenance panel.
Choose option 2 for a group.
Change the Description and/or Secure setting and press Enter.

Deleting a File Group

You can delete a file group if necessary through IDT101-01.

To delete a file group

From any Database Monitor menu, enter option 14 or 24 to open the Database Monitor File Groups Maintenance panel.
Choose 4 for a group and press Enter.
Press Enter again to confirm.

Adding a new file to a File Group

You can add a file to a file group through IDT102-01.

To add a new file to a File Group

From any Database Monitor menu, enter option 14 or 24 to open the Database Monitor File Groups Maintenance panel.
Choose 11 for a group to open the File Maintenance for File Groups panel, then press F6.
Type the File and Library and press Enter to add the record.

Changing a file in a File Group

You can make changes to a file's Library through IDT102-01.

To change a file in a file group

From any Database Monitor menu, enter option 14 or 24 to open the Database Monitor File Groups Maintenance panel.
Choose 11 for a group to open the File Maintenance for File Groups panel.
Enter 2 for the desired file and press Enter.
Change the file as needed and press Enter.

Deleting a file from a File Group

You can delete a file from a file group if necessary through IDT102-01.

To delete a file from a file group

From any Database Monitor menu, enter option 14 or 24 to open the Database Monitor File Groups Maintenance panel.
Choose 11 for a group to open the File Maintenance for File Groups panel.
Enter 4 for the desired file and press Enter.
Press Enter again to confirm.