Sample Database

The queries in this section are based on the following two databases. The first database contains employee information using two tables (Q4EMPLOY and Q4DEPT). The second database contains customer information (UTCUST, UTREP, UTOPENAR, and UTSALHSH).

It is likely that access to data in the employee file would be restricted in a real-world situation. Thoroughbred Dictionary-IV allows you to secure the data file (Link) with a password, to restrict specific terminals or operators, and to restrict display of individual Data Names (refer to security in the Dictionary-IV Developer Guide). For the purposes of illustrating the sample queries in this section, the sample data files are not secured.

From the Query-IV Reference, version 8.9.1. Open this page in the PDF