ALLBASE/SQL Reference Manual (36216-90216)

Appendix C 625

Sample DBEnvironment

C Sample DBEnvironment

The DBEnvironment used in examples throughout the ALLBASE/SQL manual set is

called

PartsDBE

. Your installation package includes the necessary ﬁles to create a working

version of this DBEnvironment so that users can try the examples while learning about

the features of ALLBASE/SQL. Also included is a set of sample applications that access

PurchDB, the main database in PartsDBE.

This appendix presents the steps for setting up the sample DBEnvironment and then

displays some important ﬁles and tables related to PartsDBE. It contains the following

sections:

• Installing the Files for PartsDBE

• Setting Up PartsDBE

• ISQL command ﬁles for creating and loading PartsDBE

• Tables in the ManufDB, PurchDB, and RecDB Databases

• Sample Program Files

Before you can use PartsDBE, you must install the sample database ﬁles, then run a setup

script to create and load PartsDBE. Optionally, you can preprocess and compile the sample

application programs.