Utilities for Modifying the Database

The DP4 utilities for modifying the database are:

• The Database Setup and Maintenance utility (MAKEDB) which allows you to modify the database data dictionary:

  • Add new tables. (See Adding a Database Table )
  • Change table definitions, including the autoincrement, security level, encryption and compression options. (See Adding a Database Table )
  • Add new fields. (See Adding a Table Field )
  • Change field definitions, including the key precedence, sequence number, data type and length, validation values and security levels. (See Adding a Table Field )
  • Change the field format flags. (See Formatting a Field )
  • Change table headings. (See Changing Table and Field Headings )
  • Change table and field names. (See Changing Table, Field and Role Names )
  • Copy tables. (See Copying Table Structures )
    
    

• The Index Link Editor (SETLINK), which allows you to change the attributes of the index links between tables, including 'Check parent' and 'Child delete'. (See Index Link Analysis and Scrutiny)

• The Number System Utility (NUMBSYS), which allows you to change the number system, depending on the programming language you intend to use. (See Selecting the Database Number System )

• The Database Reorganisation utility (REORGDB), which allows you to reorganise the database after making a structural change. (See Reorganising the Database )

• The National Language Collate setup utility (COLLATE), which allows you to change the collate sequence used for database fields of type U. (See Specifying Collate Characteristics of Key Fields )