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

Saving Your Report As an SQL Table

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

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

In this step, you save your report as a SQL 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


 Dictname:  EMPLOYEE       Schema:  EMPLOYEE
 Function:  _ Select                  x Create                   Delete
            _ Add                    _ Replace

  Enter table:   emp_office 
  -or-
  Select table
 _ EMPLOYEE.ACCOUNTING
 _ EMPLOYEE.BUDGET
 _ EMPLOYEE.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                          *** Data Table Processing ***
 ->                                                       Page     2 of     2
102020 The appending, replacing, or creating of an SQL table has been successful.
102021 A total of 100 rows have been inserted into the named SQL table.

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

 Enter table:
  -or-
 Select table
 _ EMPLOYEE.ACCOUNTING
 _ EMPLOYEE.BUDGET
 _ EMPLOYEE.DEPARTMENT
 _ EMPLOYEE.EMP_OFFICE 







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