HPlogo ALLBASE/SQL Reference Manual > Appendix C Sample DBEnvironment

Appendix C Sample DBEnvironment

MPE documents

Complete PDF
Table of Contents
Index

E0300 Edition 9 ♥
E0399 Edition 8
E0897 Edition 7

Table of Contents
Installing the Files for PartsDBE
Setting Up PartsDBE
Using SQLSetup
Creating PartsDBE
Using Setup
Listings of ISQL Command Files
STARTDBE Command File
CREATABS Command File
LOADTABS Command File
CREAINDEX Command File
CREASEC Command File
Data in the Sample DBEnvironment
ManufDB.SupplyBatches Table
ManufDB.TestData Table
PurchDB.Inventory Table
PurchDB.OrderItems Table
PurchDB.Orders Table
PurchDB.Parts Table
PurchDB.Reports Table
PurchDB.SupplyPrice Table
PurchDB.Vendors Table
RecDB.Clubs Table
RecDB.Events Table
RecDB.Members Table
Sample Program Files
The DBEnvironment used in examples throughout the ALLBASE/SQL manual set is called PartsDBE. Your installation package includes the necessary files 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 files and tables related to PartsDBE. It contains the following sections:

  • Installing the Files for PartsDBE

  • Setting Up PartsDBE

  • ISQL command files 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 files, then run a setup script to create and load PartsDBE. Optionally, you can preprocess and compile the sample application programs.



ISQL Commands

Installing the Files for PartsDBE