HPlogo IMAGE/SQL Administration Guide: HP 3000 MPE/iX Computer Systems > Chapter 6 IMAGE/SQL Transactions

Definition

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Glossary

 » Index

A transaction is a unit of work consisting of one or more SQL statements referencing one or more databases in a DBEnvironment. Work done within a transaction can be committed (made permanent) or undone (rolled back). A transaction is started with an implicit or explicit BEGIN WORK statement and is either committed with COMMIT WORK or rolled back with ROLLBACK WORK.

An IMAGE/SQL transaction is started by the first SQL statement that results in a modification or repeatable read of an IMAGE/SQL table.

Feedback to webmaster