How to Make a Report from a Table › Creating Your Report From an ASF Table › Step 2— Select a table

Step 2— Select a table

For this example, select Choose tables.

     CA OLQ Release nn.n                                *** Menu ***
 ->                                                       Page     1  of      3
114002 Choose before requesting a retrieval, display, or format activity
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 EMPLOYEE table.

     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
 _ 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