Table/View/Alias Selection panel

You use the Table/View/Alias Selection panel to select a table, view, or alias from a list produced when you have used an asterisk (*) or a pattern when specifying a Db2® object name.

Panel and field definitions

 ┌──────────────────────── Table/View/Alias Selection ─────────────────────────┐
 │                                                           Row 1 to 13 of 39 │
 │ Select one of the tables/views/aliases from the list.                       │
 │                                                                             │
 │                                                        Table                │
 │ S Owner  + Table/View/Alias Name            + Database Space    Type        │
 │   FMNUSER  ACT                                JOHND81A JOHNS81P TABLE       │
 │   FMNUSER  DEPT                               JOHND81A JOHNS81D TABLE       │
 │   FMNUSER  EACT                               JOHND81A JOHNS81R TABLE       │
 │   FMNUSER  EDEPT                              JOHND81A JOHNS81R TABLE       │
 │   FMNUSER  EEMP                               JOHND81A JOHNS81R TABLE       │
 │   FMNUSER  EEPA                               JOHND81A JOHNS81R TABLE       │
 │   FMNUSER  EMP                                JOHND81A JOHNS81E TABLE       │
 │   FMNUSER  EMPPROJACT                         JOHND81A JOHNS81P TABLE       │
 │   FMNUSER  EPROJ                              JOHND81A JOHNS81R TABLE       │
 │   FMNUSER  EPROJACT                           JOHND81A JOHNS81R TABLE       │
 │   FMNUSER  MAP_TBL                            JOHND81P JOHNS81Q TABLE       │
 │   FMNUSER  PARTS                              JOHND81A JOHNS81S TABLE       │
 │   FMNUSER  PROJ                               JOHND81A JOHNS81P TABLE       │
 │                                                                             │
 │ Command ===>                                                                │
 │  F1=Help        F2=Split       F3=Exit        F4=Expand      F7=Backward    │
 │  F8=Forward     F9=Swap       F10=Left       F11=Right      F12=Cancel      │
 └─────────────────────────────────────────────────────────────────────────────┘
S
Selection column. To select a table, type S.
Owner
The name of the owner of the table.
Table/View/Alias Name
The name of the table, view, or alias.
Database
The name of the database containing the table.
Table Space
The name of the table space containing the table.
Type
The Db2® object type.

Parent panels

This panel appears when you enter an asterisk (*) or pattern in one or more of the following fields when specifying a Db2® object name: Owner, Name, Database, Table space.

Child panels

None.

Related tasks