CA IDMS Environment › Tools for Database Definition and Maintenance

Tools for Database Definition and Maintenance

You define and maintain your database using a number of facilities.

Command Facility

The command facility is a tool used to enter:

• Physical database definition and maintenance statements
• SQL logical database definition and maintenance statements
• Utility statements

It can be run in either online or batch mode.

Note: For more information about the command facility, see the CA IDMS Common Facilities Guide.

Schema, Subschema, and DDDL Compilers

The batch and online schema, subschema, and data dictionary definition language (DDDL) compilers are used to define and maintain the logical definition of non-SQL databases:

• Schema compiler—Used to create a complete logical non-SQL database definition
• Subschema compiler—Used to create a subset view of the logical database definition for use with application programs.
• DDDL compiler—Used to create record and element definitions in the dictionary.

Utilities

You use utilities to perform maintenance operations on the database. Most utilities are executed as statements through the command facility; however, some are standalone programs.

Note: For more information about utilities, see the CA IDMS Utilities Guide.