Chapter 6 Practice with ALLBASE/SQL Using PartsDBE

Table of Contents

Setting up PartsDBE

Using SQLSetup
Using Setup Scripts
Looking at the Files Created for PartsDBE

Examining PartsDBE

Examining the Tables and Views
View Definitions
Using the INFO Command
Examining Indexes
Examining the Authority Structure
Column Authorizations

Using the Preprocessors

Sample Application Programs
For HP-UX:
For MPE/iX:

Examining Startup Parameters with SQLUtil

Creating a Schema File with SQLGEN

Purging PartsDBE

The ALLBASE/SQL software includes a sample DBEnvironment known as PartsDBE and a set of sample application programs which illustrate much of the functionality of ALLBASE/SQL. Most of the examples in the ALLBASE/SQL documentation use PartsDBE. This chapter shows you how to get practice using the components of ALLBASE/SQL by creating a version of PartsDBE which you can use to try out the examples on your own system.

Here are the topics covered:

Setting up PartsDBE.
Examining PartsDBE.
Using the preprocessors.
Examining startup parameters with SQLUtil.
Creating a schema file with SQLGEN.
Purging PartsDBE.

Chapter 6 Practice with ALLBASE/SQL Using PartsDBE

Technical documentation

» Table of Contents

» Index