HP 3000 Manuals

Using Databases [ HP Transact Reference Manual ] MPE/iX 5.0 Documentation


HP Transact Reference Manual

Using Databases 

Transact opens the database at the start of your program.  The SYSTEM
statement's BASE option allows you to define the name of the database,
the password, the type of access mode to use in opening the database, and
the locking scheme to use.  For example:

     SYSTEM MYSYS,BASE=DBASE("READER",1,1);

In this example, the database name is DBASE, the password is READER, the
access mode is one and the lock option (optlock) is one.

Access Mode 

The access mode you choose on the SYSTEM statement determines the type of
operation that you can perform on the database as well as the types of
operations other users can perform concurrently.  To simplify the
definition of the various access modes, the following terminology is
used:

   *   Read access allows the user to locate and read data entries.  The
       FIND and GET statements are used with read access.

   *   Update access allows the user to replace values in all data items
       except search and sort data items.  Update access also provides
       read access.  UPDATE, FIND, and GET statements are used with
       update access.

   *   Modify access allows the user to add and delete entries.  Modify
       access also provides update and read access.  REPLACE, PUT,
       DELETE, FIND, GET, and UPDATE statements are used with modify
       access.

For additional information on access modes, see the TurboIMAGE/V or
TurboIMAGE/XL Database Management Reference Manual.



MPE/iX 5.0 Documentation