Previous Topic: The OLQ SELECT StatementNext Topic: Some Tips On Using CA OLQ

Introducing the OLQ SELECT statement › Defining Your Data

Defining Your Data

Creating sample tables

If you want to use the SELECT statement as you proceed through this manual, you need two or more ASF-generated tables.

To create an ASF-generated table, see the CA IDMS ASF User Guide.

Sample tables used in this manual

The sample tables used in this manual are ASF-generated tables created in part from data stored in the Employee database your site receives at installation. The sample tables, which appear in Appendix A, "Sample Tables and Database", are:

The table

Contains information about

EMP

Employees in departments 3100, 4000, and 6666

DEPT

All corporate departments

JOBLIST

Position held by each corporate employee

JOBCLASS

Class and associated salary range assigned to a position

BOSTON

Employees in the Boston office

WESTON

Employees in the Weston office

SPRINGFIELD

Employees in the Springfield office

Sample database

For the most part, examples in this manual are based on the sample tables listed above. Examples that retrieve information from network records use the Employee database. The data structure diagram for the Employee database appears in Appendix A.