Version 8.1.4
 —  File Maintenance  —

Define / Modify FDT

Selecting option "C" on the File Maintenance menu displays the FDT/SDT Definition / Modification menu:

08:34:30         *****  A D A B A S   BASIC  SERVICES  *****       2006-07-20
                      -  FDT/SDT Definition / Modification  -         PFLC002

                        Code    Service
                        ----    -------------------
                         A      Add new field(s)
                         C      Change field parameters
                         D      Define new FDT
                         I      Online invert
                         S      Define/add SDT
                         ?      Help
                         .      Exit
                        ----    -------------------

          Code ......... _
          File No. ..... 50
          Field Name ... __
          Database ID .. 00105  (RD-MPM105)

   Command ==>
  PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
  Help     Def. File Exit                                           Menu

This document covers the following topics:


Add One or More Fields

From this menu you can add one or more fields to an existing Adabas file.

Start of instruction setTo add a new field definition to the field definition table (FDT) of an existing file

  1. Select option "A" (add new fields).

  2. Specify the number of the existing file.

  3. Specify a two-character field name that is not currently being used by the specified file.

  4. Press ENTER.

Note:
You can view the FDT of the existing file by selecting option "R", Database Report.

A screen similar to the following is displayed providing input fields for defining a new field:

08:39:13         *****  A D A B A S   BASIC  SERVICES  *****       2006-07-20
   DBID 1955                  -  Add New Field(s)  -                  PFLCA02

   File = 1    (EMPLOYEES)                             In Parallel .. NO 
   Enter Password if file is security protected ...

              Level I Name I Length I Format I Options             I
              ------------------------------------------------------
                    I      I        I        I                     I
                    I      I        I        I                     I
                    I      I        I        I                     I
                    I      I        I        I                     I

The option In Parallel allows processing to continue against a file while the function you have selected modifies the file. Specify "YES" to select this option. With this option, Adabas performs the function while all applications executing against the file are temporarily quiesced and suspended. File integrity is always maintained. For this reason, your applications that are executing against the file may experience difficulty. Please maintain an awareness of the impact on your environment and the consequences of performing your selected functions against a file when using this option.

With this option set to "NO" (the default), Adabas requires exclusive file control (that is, no application executing against the file) when performing the function.

The Add New Field(s) function corresponds to the Adabas utility function ADADBS NEWFIELD. The equivalent direct command is

ADD FIELD

Top of page

Change Field Parameters

From this menu you can also change the parameters of a field in an existing Adabas file.

Start of instruction setTo change the parameters of an existing field in an existing file

  1. Select option "C" (change field parameters).

  2. Specify the number of the existing file.

  3. Specify the name of the existing field to be changed.

  4. If the file is protected, enter the password.

  5. Press ENTER.

Note:
You can view the FDT of the existing file by selecting option "R", Database Report.

08:57:01        ***** A D A B A S  BASIC  SERVICES *****          2006-07-20
DBID 1955               -  Change Field Parameters  -               PFLCC02   
                                                                              
Enter New Field Length:                                                       
                                                                              
   File ........... 1                                                         
   File Name ...... EMPLOYEES                                                 
   Field Name ..... AA                                                        
                                                                              
   Field Format ... A                                                         
   Field Length ... 8                                                         
   Field Option ... __                                                        
   In Parallel .... NO                                                        
                                                                              
   File Password ..

From the resulting Change Field Parameters screen, you can change

Only one of these parameters may be changed at a time.

No modifications to records in Data Storage are made by this function. The user is, therefore, responsible for preventing references to the field that would cause invalid results because of an inconsistency between the new parameter value as defined to Adabas and the actual value contained in the record.

Start of instruction setTo change the length of the field

  1. Enter the new value in the Field Length field.

Start of instruction setTo add the "LA" (long alphanumeric) option to a field with format "A" (alphanumeric)

  1. Enter "LA" in the Field Option field.

Start of instruction setTo change the format of an elementary field from "U" (unpacked) to "P" (packed)

  1. Overwrite the "U" in the Field Format field with "P".

    An elementary field defined as format "U" can only be changed to "P" if the field

    This function corresponds to the Adabas utility function ADADBS CHANGE. The equivalent direct command is

    CHANGE FIELD file-number field-name

Top of page

Define a New Field Definition Table (FDT)

Start of instruction setTo define a new FDT

  1. Select option "D" (define new FDT) and press ENTER.

    The following screen appears, which can be used to define a new FDT for a new file:

    09:13:34         *****  A D A B A S   BASIC  SERVICES  *****       2006-07-20
       DBID 105                       -  Define FDT  -                    PFLCD02
    
       File Number ... 200                           New FDT ... Y
       Enter Field Description(s) :
    
                I Level I Name I Length I Format I Options             I
                I-------------------------------------------------------
                I   __  I  __  I   ___  I   _    I  __ __ __ __ __     I
                I   __  I  __  I   ___  I   _    I  __ __ __ __ __     I
                I   __  I  __  I   ___  I   _    I  __ __ __ __ __     I
                I   __  I  __  I   ___  I   _    I  __ __ __ __ __     I
                I   __  I  __  I   ___  I   _    I  __ __ __ __ __     I
                I   __  I  __  I   ___  I   _    I  __ __ __ __ __     I
                I   __  I  __  I   ___  I   _    I  __ __ __ __ __     I
                I   __  I  __  I   ___  I   _    I  __ __ __ __ __     I
                I   __  I  __  I   ___  I   _    I  __ __ __ __ __     I
                I   __  I  __  I   ___  I   _    I  __ __ __ __ __     I
    
    
      PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
      Help     Def SDT   Exit      Def File  Disp FDT                   Menu

    FDTs for existing files cannot be redefined with this option.

    This function corresponds to the Adabas utility function ADACMP COMPRESS. The equivalent direct command is

    DEFINE FDT

Top of page

Invert a File Online

Note:
This function is only available for Adabas version 7 or above databases.

Selecting "Online Invert" (option "I") displays the following screen:

09:17:06         *****  A D A B A S   BASIC  SERVICES  *****       2006-07-20
 DBID 105                      - Online Invert -                    PFLCI02

 File Number ... 5      EMPLOYEES
 Password ......

 Enter the definition, using the syntax of the ADADBS ONLINVERT utility:

  ______________________________________________________________________
  ______________________________________________________________________

 Note:  Only one Invert Process can be active for a file at any time.

 Examples:
  FIELD='AA'                          HYPDE='01,HD,20,A,NU,MU=AA,AB'
  SUBDE='SB=AA(1,5)'                  PHONDE='PH(AA)'
  SUPDE='SP=AA(1,5),BB(1,2),CC(3,5)'  COLDE='1,CD=AA'

 Enter Descriptor information and press 'enter'

PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help               Exit                                           Menu

The specified file must be currently loaded.

You must use the ADADBS ONLINVERT syntax. PF1 provides help information for this syntax; see the Adabas Utilities documentation for additional information.

Only one descriptor can be specified per process.

Only one invert process can be active for a file at any time. If an attempt is made to start a second invert process before the first one has completed, a response code 64 is returned.

The equivalent direct command is

ONLINE INVERT

Top of page

Define a Special Descriptor Table (SDT)

Option "S", "Define/add SDT", is available only if an FDT exists but no file control block (FCB) exists for the file (for example, if the FDT has been created but no records loaded, or if the file was deleted with the option to retain the FDT).

Selecting option "S" displays the following screen, which can be used to define special descriptors in an existing FDT for a new file:

09:24:41         *****  A D A B A S   BASIC  SERVICES  *****       2006-07-20
 DBID 105                       -  Define SDT  -                    PFLCH02

 File Number ... 50
 Password ......

 Enter SDT-Definition, using the syntax of the ADACMP Utility:
    ______________________________________________________________________
    ______________________________________________________________________
    ______________________________________________________________________
    ______________________________________________________________________
    ______________________________________________________________________
    ______________________________________________________________________
    ______________________________________________________________________
    ______________________________________________________________________
    ______________________________________________________________________
    ______________________________________________________________________

 Enter SDT information and press 'enter'

PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help     Def File  Exit      Refresh                              Menu

Start of instruction set To define new super-/sub-/hyperdescriptors, phonetic descriptors, and super-/subfields in an existing FDT

  1. Use ADACMP syntax (see the Adabas Utilities documentation) on this screen.

    This function corresponds to the Adabas utility function ADACMP COMPRESS. The equivalent direct command is

    DEFINE STD

Top of page