HP 3000 Manuals HP 3000 Manuals
HP ALLBASE/SQL Interface The interface between HP ALLBASE/4GL and HP ALLBASE/SQL consists of the following components in HP ALLBASE/4GL: * Dictionary table definitions. * Dictionary select list definitions. * SQL logic blocks. This manual contains a description of the facilities in HP ALLBASE/4GL that allow you to use HP ALLBASE/SQL databases in conjunction with HP ALLBASE/4GL applications. It assumes that you are familiar with the basic features and terminology of HP ALLBASE/SQL. Consequently, this manual does not contain detailed descriptions of any HP ALLBASE/SQL features or the syntax and usage of HP ALLBASE/SQL commands. Refer to the HP ALLBASE/SQL Reference Manual for more information about using HP ALLBASE/SQL. Dictionary Items The dictionary contains facilities so that you may define and create HP ALLBASE/SQL base tables from HP ALLBASE/4GL. The table definitions use field specifications and record layouts to define the columns of a table. HP ALLBASE/4GL select lists are "virtual" HP ALLBASE/SQL tables. They are built from the columns of one or more base tables, and can use aggregate expressions. A select list definition uses HP ALLBASE/4GL field specifications to define the columns of the select list. Chapter 5 of this manual contains a detailed explanation of the HP ALLBASE/4GL facilities for defining HP ALLBASE/SQL tables and select lists. SQL Logic Blocks HP ALLBASE/4GL SQL logic blocks provide the means of passing SQL commands between HP ALLBASE/4GL and HP ALLBASE/SQL. An SQL logic block can contain up to eight SQL commands. An SQL logic block is invoked from a process or function by the SQL command. Chapter 11 of this manual describes SQL logic blocks.