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

Step 2— Select a table

For this example, select Choose tables.

                      CA, Inc.
     CA OLQ Release nn.n                                *** Menu ***
 ->                                                       Page     1  Of      3
122000 Select an option and press the ENTER key.

        Select                                              Command/       Show/
 Pfkey  Option  Description                                Screen Name     Help

                --->  Data Source for Report  <---
          _     Choose tables                              TABle             _


                --->  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         3=QUIT         4=MESSAGE         5=GLOBAL HELP         8=FWD

Specify SELECT and select the EMPLOYEE table.

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

 Dictname:                 Schema:
 Function:  X Select                  _ Create                _ Delete
            _ Add                    _ Replace

 Enter table:
 -or-
 Select table
 _ DEMO.TAB1
 _ EMPDEMO.COVERAGE
 _ EMPDEMO.DENTAL_CLAIM
 _ EMPDEMO.DEPARTMENT
 s EMPDEMO.EMPLOYEE  
 _ EMPDEMO.EMPOSITION
 _ EMPDEMO.EXPERTISE
 _ EMPDEMO.HOSPITAL_CLAIM
 _ EMPDEMO.INSURANCE_PLAN
 _ EMPDEMO.JOB
 _ EMPDEMO.NON_HOSP_CLAIM
 1=HELP        3=QUIT        4=MESSAGE        6=MENU        7=BWD        8=FWD