HP NonStop G-Series - Manual (Page 89)

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 8-3
1. In the Catalogs field, double-click on the name of the catalog. Tables
located in the catalog are displayed in the Tables field. Views located in
the catalog are displayed in the Views field.
• To choose a table, double-click on its name in the Tables field.
• To choose a view, double-click on its name in the Views field.
2. The columns in the table or view are displayed in the Columns pane, as
shown in Figure 8-4. The following attributes of the columns are also
displayed: table name, table alias, column name, data type, whether the
column is part of the primary key, and whether the column accepts null
values.
3. Repeat steps 1 and 2 to choose additional tables or views.
Figure 8-4. Columns Pane.
Create the Columns List
Use the Columns pane shown in Figure 8-4 to create the columns list in the
SELECT statement.
1. In the Columns pane, click on the name of the column you want to add
to the columns list. The column is displayed in the Select Columns field
of the Columns pane.
If you want to remove a column from the columns list, double-click on
the name of the column. The column is removed from the Projection
Elements field.
2. Edit the Projection Elements field to create any expressions you want.
3. Repeat Steps 1 and 2 to add more elements to the columns list.
4. To complete creation of the columns list, click on Predicate. A partial
SELECT statement is displayed in the Select Text pane, as shown in
Figure 8-5.