HP MPE/iX 6.x Operating System TurboIMAGE/XL and QUERY/V

TurboIMAGE/XL and QUERY/V

Together, TurboIMAGE/XL and QUERY/V provide a database managemen t system. TurboIMAGE/XL is a set of programs and procedures y ou can use to de￿ne, create, access, and maintain a database. QUERY/V is a database inquiry facilit y that provides a simple method of accessing a T urboIMAGE/XL database without requiring programming. Y ou can use QUERY/V interactively.

TurboIMAGE/XL components are:

DBSCHEMA, a subprogram that creates a root ￿le.

DBUTIL, a subprogram that y ou can use to create, purge, or report on a database, erase data from data sets, and enable and disable logging and reco very options.

TurboIMAGE/XL procedures, a set of library routines that allow loading, accessing, and manipulating of data in a database.

Creating a Schema

You can use DBSCHEMA to create a root ￿le con taining the structural de￿nition of a database by using a schema. A schema analyzes data and formalizes data relationships. The schema is a summary of all the data relationships in a data base and stored as a separate text ￿le. The format used in a sc hema is TurboIMAGE/XL's database description language. You can enter schema information in an MPE/iX text ￿le, following the database description language format. Sc hema information includes:

Password and user class

Designation of read/write capability for data sets

Data items

Designation of read/write capabilities for data items

Manual master set

Automatic master set

Detail set

Paths from master sets to detail sets

Key items, identi￿ed by path counts

Capacity for each set (speci￿cation of a prime n umber is recommended for a master set)

Creating a Root File

Once you have created a schema in an MPE/iX text ￿le, y ou can use the schema processor, DBSCHEMA, to create a root ￿le and store in it an in ternal description of the database, based on the schema in the text ￿le. The root ￿le is part of a database and con tains all the database structural information required b y TurboIMAGE/XL and QUERY/V.

The syntax for the command to run the sc hema processor is:

:RUN DBSCHEMA.PUB.SYS;PARM=n

where:

7-14 Data Management