How to Save a Table From a Report › Viewing Your SQL Table

Viewing Your 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 look at the table you just created.

Choose Select and select the EMP_OFFICE table.

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


 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

Select all columns for viewing. When you select the table name, you automatically select all of the columns within that table.

     CA OLQ Release nn.n                          *** Column Select ***
 ->                                                       Page     1 of     1
124000 Select columns, specify selection criteria and press ENTER key

   Columns Currently Selected:    0     Selection Criteria     Distinct N Y/N
 x EMP_OFFICE 
 _ 03 EMP-ID-0415
 _ 03 EMP-LAST-NAME-0415
 _ 03 OFFICE-CODE-0450
 _ 03 OFFICE-CITY-0450









 Additional selection criteria:


                                   Proceed to Selection Criteria Screen? N Y/N
 1=HELP          3=QUIT          4=MESSAGE          6=MENU          PA2=REFRESH