Retrieving Information from a Table › Retrieving All Columns

Retrieving All Columns

Use an asterisk (*) To retrieve all of the columns defined for a table, you can use an asterisk (*) in the SELECT statement. An asterisk is shorthand for all of the table's columns. By using an asterisk, you don't need to know the table's column names in order to retrieve data.

Example

To display the DEPT table, enter:

select * from dept ! display

                                   DEPT REPORT
                                    mm/dd/yy

      DEPTID                       DEPTNAME                        MGRID
      ──────     ─────────────────────────────────────────────     ─────
        1000     PERSONNEL                                          0013
        2000     ACCOUNTING AND PAYROLL                             0011
        3100     INTERNAL SOFTWARE                                  0003
        3200     COMPUTER OPERATIONS                                0004
        4000     PUBLIC RELATIONS                                   0007
        5100     BRAINSTORMING                                      0015
        5200     THERMOREGULATION                                   0349
        5300     BLUE SKIES                                         0321
        6666     EXECUTIVE ADMINISTRATION                           0030
     END OF REPORT

If all of the columns or all of the rows of the table don't fit on one screen, use these PF keys to scroll:

Note: If your PF key assignments are different than those described above, see your CA IDMS/DC system administrator.