HP 3000 Manuals HP 3000 Manuals
Tutorial Files
The following files are supplied with the tutorial.
Example Solutions
There are three example solutions, one for each task. Specification
files, execution files, and printfiles (examples of printed output
directed to disk files) are supplied for each task.
Specification Solutions
The specification file solutions are:
Table B-1. Specification Solution Files
SOLUTN1 Solution to the first report.
SOLUTN2 Solution to the second report.
SOLUTN3 Solution to the third report.
These files are held in group BRWSPEC.ITF3000.
Execution Solutions.
The native mode execution files are:
Table B-2. Execution Solution Files
SOLUTN1 Solution to the first report.
SOLUTN2 Solution to the second report
SOL3DIR Solution to the third report. (Specification file SOLUTN3 compiled
with selection set DIRECTORS.)
SOL3SMN Solution to the third report. (Specification file SOLUTN3 compiled
with selection set SALES-MANAGERS.)
These files are held in group BRWEXEC.ITF3000.
Printfile Solutions.
The printfiles are:
Table B-3. Printfile Solution Files
SOLUTN1 Solution to the first report.
SOLUTN2 Solution to the second report.
SOL3DIR1 Solution to the third report. (Execution file SOL3DIR run without
data restriction.)
SOL3DIR2 Solution to the third report. (Execution file SOL3DIR run with
parameter CUSTOMER-NO > "000002".)
SOL3SMN1 Solution to the third report. (Execution file SOL3SMN run with
parameter AREA = "WESTERN".)
SOL3SMN2 Solution to the third report. (Execution file SOL3SMN run with
parameter AREA = "WESTERN" and CUSTOMER-NO > "000002".)
SOL3SMN3 Solution to the third report. (Execution file SOL3SMN run with
parameter AREA = "WESTERN" and CUSTOMER-NO = "000006".)
These files are held in group BRWONLNE.ITF3000.
BRWDIC File.
This is the BRWDIC file that describes the TOYDB. You do not need a data
dictionary to run the tutorial. See the HP ALLBASE/BRW Reference Manual
for a description of data dictionaries and the BRWDIC file. The BRWDIC
file is called BRWDIC, and is held in group PUB.ITF3000.
Database TOYDB.
This is a HP TurboIMAGE/iX database, with six data sets containing the
following records:
CUSTOMERS 8 records
ORDER-MASTER 10 records
ORDERS 11 records
PRODUCTS 10 records
INVOICES 1 record
ORDER-DETAILS 10 records
INVOICES and ORDER-MASTER are not used in the tutorial examples. The
data sets are:
TOYDB (root file), TOYDB01, TOYDB02, TOYDB03, TOYDB04, TOYDB05, and
TOYDB06. They are held in group PUB.ITF3000.
There are no passwords or access restrictions to the TOYDB database.
The database creator is MGR.
Amending the TOYDB
You can add or amend records in the TOYDB, for example using QUERY, but
if you do so, you can spoil the output of the task reports. Therefore,
if you wish to add or amend records, please copy the TOYDB and work on
the copy.