HP 3000 Manuals

HP ALLBASE/4GL Developer Self-Paced Training Guide

Summary 

SQL logic blocks are used to pass SQL commands to HP ALLBASE/SQL. The
important characteristics of SQL logic blocks are listed below.

   *   An SQL logic block comprises a header and the logic block details.
       You cannot complete the details for an SQL logic block until you
       have defined the header.

   *   If an SQL logic block contains a SELECT command it must be the
       only command in the logic block.  An SQL logic block can contain
       up to eight SQL commands if it does not contain a SELECT command.

   *   SQL logic blocks must be generated to produce an executable form
       of the commands in the logic block.

   *   The commands in an SQL logic block are executed by the SQL command
       in a function or a process.

   *   To retrieve a row from an HP ALLBASE/SQL table, you can use a
       SELECT command in an SQL logic block to declare and open a cursor,
       and then use a FILE *NEXT command in a function or process to
       retrieve the row into the HP ALLBASE/4GL file buffer.

   *   HP ALLBASE/SQL requires you to issue an explicit COMMIT WORK
       command to complete a transaction and make it permanent in the
       database.

You have completed all the logic you need for now.  Complete the Self
Test Questions for this chapter.  Then you can start testing the
application.  Chapter 5, Lesson 9 explains the procedures for testing
your application.

MPE/iX 5.0 Documentation