HPlogo ALLBASE/SQL Reference Manual > Chapter 1 Introduction

ALLBASE/SQL Objects

MPE documents

Complete PDF
Table of Contents
Index

E0300 Edition 9 ♥
E0399 Edition 8
E0897 Edition 7

The following structures play a significant role in the use of an ALLBASE/SQL database and are known as database objects:

  • Tables

  • Views

  • Columns (in tables and views)

  • Authorization groups

  • Indexes (on tables)

  • Hash structures (for tables)

  • Constraints

  • Rules (on tables)

  • Procedures

  • DBEFiles

  • DBEFileSets

  • TempSpaces

  • Modules

Many of the SQL statements let you create and then create and manipulate objects as described below:

  • Data in tables and views

  • Columns within tables and views

  • Grant authorities to authorization groups

  • Indexes for specific tables

  • Hash structures for specific tables

  • Constraints on specific tables, views, or columns

  • Rules on specific tables

  • Procedures containing SQL and control flow statements

  • DBEFiles and associate them with DBEFileSets

  • TempSpaces that are used for sorting

  • Modules when you preprocess an application program containing SQL statements



Using Queries

ALLBASE/SQL Users