HP 3000 Manuals

HP ALLBASE/4GL Developer Reference Manual Vol. 2

SQL Logic Block Details Screen 

This screen allows you to enter the SQL commands that make up an SQL
logic block.

Screen Image 


            

Field Descriptions 

SQL Logic Block.  Enter the name of an SQL logic block that has been
defined on the SQL logic block header screen.

SQL Commands.  This is a free format text entry area that allows you to
enter one or more valid SQL commands.  Terminate each command with a
semicolon.

If the SQL block contains a SELECT command, this must be the only command
in the SQL logic block.  If the SQL block does not contain a SELECT
command, it can contain up to eight SQL commands that generate into
stored database sections.  The SQL logic block may contain additional SQL
commands that do not generate into stored database sections.

The SQL commands that do not generate into stored database sections are:

   *   BEGIN WORK.

   *   COMMIT WORK.

   *   ROLLBACK WORK.

   *   SAVEPOINT.

   *   SQLEXPLAIN.

There are some restrictions on the commands you can use in SQL logic
blocks.  Refer to chapter 9 for details of these restrictions.

Function Keys 

f1       Database Items  Cancels the current screen and displays the
        dictionary database items menu.

f2       SQL Blk Header  Cancels the current screen and displays the SQL
        logic block header screen.

f3       SQL Sel.  Details  Cancels the current screen and displays the
        SQL logic block details screen.

f4       Generate SQL  Generates the SQL logic block.

Additional Information 

You can include a note or a comment in the SQL logic block with the
following statement:

     NOTE [ text of note...]

Refer to the HP ALLBASE/SQL Reference Manual for further information
about the use and syntax of HP ALLBASE/SQL commands.

Generating SQL Logic Blocks.   

You must generate an SQL logic block before the application can use it.
To generate an SQL logic block, press the  Generate SQL  function key or
select the SQL Logic Blocks option on the generates menu selected from
the main menu.

MPE/iX 5.0 Documentation