Maintaining File Schema Definitions

#### Search Results

Search

# Maintaining File Schema Definitions

This section describes the following topics:

- Listing File Schema Definitions

- Adding File Schema Definitions

- Modifying File Schema Definitions

- Copying File Schema Definitions

- Deleting File Schema Definitions

## Listing File Schema Definitions

To use the Adabas Auditing Configuration to list the File Schema definitions stored in the Auditing system file, complete the following steps:

- Select option G from the Adabas Auditing Configuration Main Menu.

  The List of File Schema screen appears showing all File Schema definitions in the Adabas Auditing Configuration.

      20:15:22        ***** A D A B A S  AUDITING CONFIGURATION *****      2025-08-14
                                    List of File Schema                     M-RP1130

        Sel Name                              ID       Pub
        --- --------------------------------  -------  ---
         _  $CORGFB COR CONFIGURATION         $CORGFB   Y
         _  #CORBHR                           #CORBHR   Y
         _  #CORBHX                           #CORBHX   Y
         _  #CORBPR                           #CORBPR   Y
         _  #CORDPR                           #CORDPR   Y
         _  #CORFPR                           #CORFPR   Y
         _  #CORFSR                           #CORFSR   Y
         _  #CORGPR                           #CORGPR   Y
         _  #CORPAR                           #CORPAR   Y
         _  #CORPAX                           #CORPAX   Y
         _  #CORRCB                           #CORRCB   Y
         _  #CORRCC                           #CORRCC   Y
         _  #CORRCO                           #CORRCO   Y
         _  #CORSSR                           #CORSSR   Y

       Command ==>
      Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
            Help  Gen   Exit        Repos ID     -     +                      Menu

  The following tables describe the options on this menu.

  Sel | Allows you to:
  --- | ---
  M | Modify a File Schema definition
  C | Copy a File Schema definition
  D | Delete a File Schema definition
  PF Key | Allows you to:
  PF1 | Get screen help
  PF2 | Generate a File Schema from Predict
  PF3 | Exit this screen and return to the previous screen
  PF4 | Add a new File Schema definition
  PF5 | Reposition to a specific File Schema definition in the list
  PF6 | Toggle between the sorting of File Schema by ID or Name
  PF12 | Exit this screen and return to the main menu

  Note
  You can only delete or modify a File Schema if it has not yet been published (by pressing F5). Once a File Schema is published, it cannot be changed.

## Adding File Schema Definitions

To use the Adabas Auditing Configuration to generate a File Schema definition using Predict, complete the following steps:

1. Select G from the Adabas Auditing Configuration main menu to list the File Schema definitions, as described earlier in Listing File Schema Definitions.

2. Press PF4 (Add).

   The Predict Parameters screen appears.

       11:55:22        ***** A D A B A S  AUDITING CONFIGURATION *****      2021-03-18
       FDIC=(1955,13)                Predict Parameters                     M-RP1121

       FB ID ........... _______

       File ID ......... * ________________________________
       Target file ID .. * ________________________________

       ----------  Generation Information ----------

       User ..............
       Date ..............
       Time ..............
       FDIC .............. DBID ..       FNR ..

       Adabas version ....
       Occurrences used ..
       Full format .......

       Command ==>

       Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
             Help        Exit        Exec  Sel   Unlnk                         Menu

3. Update the fields on this screen as described in the following table:

   Field Name | Description | Default
   --- | --- | ---
   FB ID | A unique ID for the File Schema definition. The ID must be between one and seven characters long. | none
   File ID | The name of a Predict file with a file type of Adabas (A) or Adabas user view (U). Place your cursor on this field and press PF6 to select a file from a List of Predict Files screen. To select from the list screen, type an "S" next to the file you want to use and press PF5. | none
   Target file ID | The name of a Predict file with a file type of sequential (S). This file may be used to insert space notation (nX) into the File Schema. For fields in the target file with matching definitions in the File ID file (in other words, if a field exists with the same field long name), a short name clause is generated. For fields that do not have a matching definition in the File ID file, an appropriate space notation (nX clause) is generated. The spaces defined by nX clauses can be filled using a user exit. Place your cursor on this field and press PF6 to select a file from a List of Predict Files screen. To select from the list screen, type an "S" next to the file you want to use and press PF5. | none

4. When you first create a definition, the remaining fields on this screen are blank. However, when you modify the definition later, the fields are filled in, although you cannot modify them. These display-only fields are described in the following table:

   Field Name | Description
   --- | ---
   FDIC=(top of screen) | The current database and file number of the Predict file.
   User | The user ID of the user who generated the File Schema.
   Date | The date the File Schema was generated.
   Time | The time of day the File Schema was generated.
   FDIC…DBID..FNR | The database and file number of the Predict file.
   Adabas version | The version of Adabas for which the File Schema was generated.
   Occurrences used | How multiple occurrences of PE and MU fields are generated in the File Schema and resulting field table (GFFT). A value of "M" indicates that the maximum number of occurrences should be generated (191). A value of "N" indicates that no occurrences will be generated. A value of "Y" indicates that the number of occurrences defined by the Predict Occ attribute should be generated.
   Full format | Whether the full File Schema was generated. The full File Schema includes the length and format of Adabas fields. A value of "Y" indicates that the full File Schema was generated. A value of "N" indicates it was not.

   Note
   The File Schema can only be modified or deleted if it has not yet been published.

5. When you have supplied values for the FB ID, File ID, and Target file ID fields, press PF5 to start generating the File Schema.

   A small window appears requesting more information:

       +-----------------------------+
       ! Adabas Version ...* I7      !
       ! Occurrences used..* Y       !
       ! Full format ....... Y (Y/N) !
       +-----------------------------+

6. Update the fields on this small window as described in the following table:

   Field Name | Description | Default
   --- | --- | ---
   Adabas version | The version of Adabas for which the File Schema will be generated. The version should be expressed as "I7" or "R7". If you want special fields and descriptors included in the generated FB and corresponding field tables (GFFTs), specify "R7". | I7
   Occurrences used | How multiple occurrences of PE and MU fields are generated in the FB. A value of "M" indicates that the maximum number of occurrences should be generated (191). A value of "N" indicates that no occurrences will be generated. A value of "Y" indicates that the number of occurrences defined by the Predict Occ attribute should be generated. | Y
   Full format | You cannot edit this parameter. It indicates that the full File Schema should be generated. | Y

7. When these fields are set appropriately, press Enter.

   The File Schema definition and field table (GFFT) are generated and the File Schema screen appears.

8. Press PF5 to save the File Schema definition in the Auditing system file. After saving, the File Schema can no longer be deleted or modified.

## Modifying File Schema Definitions

To use the Adabas Auditing Configuration to modify a File Schema definition in the Auditing system file:

1. List the File Schema definitions in the Adabas Auditing Configuration, as described earlier in Listing File Schema Definitions.

2. Locate the definition you want to modify on the screen and enter an M in the Sel column for that definition.

   You can locate the definition you want in the list by pressing the PF7 (F7) or PF8 (F8) keys to scroll through the list. You can also press PF2 (F2) to specify the ID of the definition to which the list should be repositioned.

   An appropriate File Schema definition screen appears for the File Schema you selected.

3. For information about the fields on this screen, refer to the field descriptions described earlier in Adding File Schema Definitions.

   Note
   You cannot alter the ID of the File Schema definition. If you want to rename a File Schema definition, first copy it using the ID you want and then delete the original.

4. When all modifications have been made, press PF5 to save the changes. After saving, the File Schema can no longer be modified or deleted.

## Copying File Schema Definitions

To use the Adabas Auditing Configuration to copy a File Schema definition in the Auditing system file:

1. List the File Schema definitions in the Adabas Auditing Configuration, as described in Listing File Schema Definitions.

2. Locate the definition you want to copy on the screen and enter a C in the Sel column for that definition.

   You can locate the definition you want in the list by pressing the PF7 (F7) or PF8 (F8) keys to scroll through the list. You can also press PF2 (F2) to specify the ID of the definition to which the list should be repositioned.

   A dialog appears requesting a Name and ID for the copy of the File Schema definition.

       Enter new
        Name: ________________________________
          ID: ________
        or press PF3 to cancel

3. Specify new, unique Name and ID for the copy of the File Schema definition and press Enter.

   The File Schema definition is copied and the copy appears on the List of File Schema screen.

## Deleting File Schema Definitions

To use the Adabas Auditing Configuration to delete a File Schema definition in the Auditing system file:

1. List the File Schema definitions in the Adabas Auditing Configuration, as described in Listing File Schema Definitions.

2. Locate the definition you want to delete on the screen and enter a D in the Sel column for that definition and press Enter. The File Schema definition is deleted.

   You can locate the definition you want in the list by pressing the PF7 (F7) or PF8 (F8) keys to scroll through the list. You can also press PF2 (F2) to specify the ID of the definition to which the list should be repositioned.

   Note
   The File Schema can only be modified if it has not yet been published.

### On this page

- Listing File Schema Definitions
- Adding File Schema Definitions
- Modifying File Schema Definitions
- Copying File Schema Definitions
- Deleting File Schema Definitions