TurboIMAGE/XL has a transaction logging and reco very system with the capability of recovering a database from a transaction-orien ted log ￿le in the ev ent of a system failure. DBUTIL allows you to enable or disable these options.

Creating a Data Base

Once you have created a root ￿le, y ou can use DBUTIL to create the database described in the root ￿le. To create the database, y ou must be logged onto the system with the same log-on used to create the root ￿le. DBUTIL creates data sets according to the speci￿cations in the internal description of the sc hema. When created, data sets are initialized to zero and contain no data.

Figure 7-5 sho ws an example of creating a database. In this case, the man ual master set, CUSTOMER , has a primary k ey item named ACCOUNT pointing to the detail set SALES. The automatic master set, DATE-MASTER , has a primary k ey item named DATE that also poin ts to the detail set SALES.

Figure 7-6. Creating a Data Base

TurboIMAGE/XL Procedures

TurboIMAGE/XL procedures are a set of library routines that allo w you to load, access, and manipulate data in the database. Y ou can call them from HP C/iX, COBOL II/XL, HP FORTRAN 77/iX, and HP P ascal/iX application programs.

You must be the creator of the database or kno w its database passw ord word to use TurboIMAGE/XL procedures. (The database passw ord is an optional ASCII string that you can specify with the DBUTIL commands CREATE or SET. It de￿nes a passw ord to use for executing TurboIMAGE/XL procedures and DBUTIL commands, suc h as as PURGE and ERASE. If no database passw ord is de￿ned, then only the database creator can operate them.) The database creator can use a semicolon (;) as a database passw ord to bypass all internal database securit y. You need not be logged on to the same group and accoun t that contains the database root ￿le and the data sets. Y ou can perform these procedures on a remote database. TurboIMAGE/XL procedures are in the follo wing categories:

Database access

DBOPEN

7-16 Data Management