How to Make a Report From More Than One Table › Creating your report › Step 2— Select tables

Step 2— Select tables

When you sign on to CA OLQ, the first screen you see is the Menu screen. Chapter 2 describes how to sign on to CA OLQ.

For this example, select Choose tables.

                          CA Software
     CA OLQ Release nn.n                                *** Menu ***
 ->                                                       Page     1  of      3
107017 CA OLQ Release nn.n
107019 Copyright(C) 2003 CA,Inc.
122000 Select an option and press the ENTER key
        Select                                              Command/       Show
 Pfkey  Option  Description                                Screen Name     Help

                --->  Data Source for Report  <---
          X     Choose tables                              TABle
          _     Choose subschema                           SUBschema         _

                --->  Retrieval Activity  <---
          _     Choose records from selected subschema     RECord            _
          _     Choose columns for report                  COLumn            _
          _     Retrieve data to build report              RETrieve          _
          _     Alter database access strategy             LINkage           _

                --->  Processing Mode  <---
          _     Execute or create a predefined routine     QFIle             _
          _     View existing or save current report       SAVe              _
          _     Submit batch report request                BATch             _

 1=HELP         2=GLOBAL HELP         3=QUIT         4=MESSAGE         8=FWD

Specify SELECT and select the DEPARTMENT and EMPLOYEE tables.

      CA OLQ Release nn.n                          *** Table Processing ***
  ->                                                       Page     1 of     2
 138000 Select function, table(s) and press the ENTER key

     Owner:  DOC1
   Catalog:  ASFDICT       Location:
  Function:  s Select                 _ Create                _ Delete
             _ Add                    _ Replace

  Enter table:
  -or-
  Select table
  _ ACCOUNTING
  _ BUDGET
  s DEPARTMENT
  _ EMP-TABLE
  s EMPLOYEE
  _ EMPLOYEE TABLE
  _ EMPLOYEE-DATA
  _ JOB SALARIES
  _ MELROSE EMPLOYEES
  _ OLQ EXAMPLE
  _ PERSONNEL
  1=HELP           3=QUIT           4=MESSAGE           6=MENU           8=FWD