How to Save a Table From a Report › Saving Your Report As an ASF Table

Saving Your Report As an ASF Table

Note: Before beginning this step, make sure that the access switch has been set to olq.

For information on setting the access mode switch, see Step 1? Select the type of table.

Before you begin, make sure that you are signed on to the correct ASF dictionary. Ask your DBA or support staff to make sure you are signed on to the right dictionary.

In this step, you save your report as an ASF table. Type table in the command line to proceed to the Table Processing screen.

Select Create. Name your table emp-office.

      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:  _ Select                  x Create                  Delete
             _ Add                    _ Replace

  Enter table:   emp-office 
  -or-
  Select table
  _ ACCOUNTING
  _ BUDGET
  _ DEPARTMENT









  1=HELP           3=QUIT           4=MESSAGE           6=MENU           8=FWD

CA OLQ responds with a message that your table has been defined. The EMP-OFFICE table is listed.

      CA OLQ Release nn.n                          *** Table Processing ***
  ->                                                       Page     1 of     2
 102017  Table processing has been successfully completed 
 138000 Select function, table(s) and press the ENTER key
     Owner:  DOC1
   Catalog:  ASFDICT       Location:
  Function:  X Select                 _ Create                _ Delete
             _ Add                    _ Replace

  Enter table:
  -or-
  Select table
  _ ACCOUNTING
  _ BUDGET
  _ DEPARTMENT
  _ EMP-OFFICE 







  1=HELP           3=QUIT           4=MESSAGE           6=MENU           8=FWD