HPlogo QUERY/V Reference Manual: HP 3000 MPE/iX Computer Systems > Chapter 3 QUERY/V COMMANDS

TRANSBEGIN

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

Marks the beginning of a logical logging transaction.

Syntax

   T[RANSBEGIN] [data base name:] ["text"]

Parameters

data base name

is the name of a currently open data base. If no data base name is specified, the transactions are logged against the data base opened with the DEFINE or DATA-BASE= command.

"text"

is an optional character string to be written to the log file. It can contain any information that you might want to include about the transaction.

Discussion

This command allows you to designate the beginning of a logical logging transaction from the QUERY subsystem in a similar manner to the IMAGE DBBEGIN intrinsic.

A transaction is defined as a sequence of one or more modifications which changes a data base from one consistent state to another. Logging allows you to keep a record of transactions in the event of a system failure. Marking the transaction with a TRANSBEGIN and TRANSEND, allows you to restore your data base to a consistent state by suppressing those transactions that failed to complete. For further information on transaction logging, refer to the IMAGE Reference Manual.

Logging must have already been enabled from the IMAGE subsystem for the TRANSBEGIN command to work. Consult your data base administrator about enabling the logging facility. If logging has not been enabled, you will receive the following message:

   LOGGING NOT ENABLED FOR THIS USER

If you enter the TRANSBEGIN command twice without entering an intervening TRANSEND command, the following message is printed:

      A TRANSACTION IS IN PROGRESS

      TRANSEND MUST BE CALLED BEFORE ANOTHER TRANSBEGIN

Entering EXIT while transaction logging is in effect will not abort the logging process. Note, however, that when logging completes, QUERY performs an implicit TRANSEND, your data base is closed, and the subsystem is exited.

Feedback to webmaster