HP 3000 Manuals

HP ALLBASE/4GL Developer Self-Paced Training Guide

Defining an SQL Logic Block 

Defining an SQL logic block is similar to defining a function.  You must
define an SQL logic block header, then define the details for the logic
block, and finally, generate the logic block to convert it to an
executable form.

The screens you use to define SQL logic blocks are accessible from the
logic menu.

To create the find_prod SQL logic block, you must first create the logic
block header.  To do this, display the SQL logic block header screen.

This screen is similar in appearance and operation to the function and
process header screens.

Menu Path 

To access this screen: 

   1.  From the main menu, select the Logic option.

   2.  Select SQL Logic Blocks.

   3.  Choose Header.

Screen Description 

This screen enables you to enter a brief description of the SQL logic
block for documentation purposes.

	       Click here to view figure.
          SQL Logic Block Header Screen 

To enter the field values: 

        Field                 Entry                         Explanation 

---------------------------------------------------------------------------------------

SQL Logic Block Name  find_prod             This is the name of the SQL logic block
                                            within the applications.

Description           Enter a suitable
                      description.

To complete this command: 

   1.  Press the  Commit Data  function key to create the SQL logic block
       header.

Now go to the SQL Logic Block Details screen to create the logic block
commands.

MPE/iX 5.0 Documentation