HP 3000 Manuals

HP ALLBASE/4GL Developer Self-Paced Training Guide

Another SQL Logic Block 

The training application requires one further SQL logic block, the commit 
SQL logic block, which is called from the product_proc process.

SQL logic block - commit 

The commit SQL logic block contains the single command:

     COMMIT WORK;

To enter this command: 

   1.  Define the the SQL logic block header.

   2.  Enter the details for the SQL logic block on the SQL logic block
       details screen.

Remember to terminate the command with a semicolon, and generate the SQL
logic block after you create it.

HP ALLBASE/SQL requires you to issue an explicit COMMIT WORK to complete
a transaction and make it permanent in the database.  If you terminate a
transaction or attempt to start a new transaction without issuing a
commit work command, HP ALLBASE/SQL reverses any currently open
transaction.

You can use an SQL logic block called from an HP ALLBASE/4GL logic block
to issue the COMMIT WORK command.

MPE/iX 5.0 Documentation