Selects DBMS columns for the view descriptor
| Requirement: | This statement is required. |
|---|---|
| Interactions: | RESET |
| applies to view descriptors | |
| Note: | The SELECT statement specifies which DBMS columns in an access descriptor to include in a view descriptor. |
| Tip: | To clear your current selections when creating a view
descriptor, use the RESET ALL statement. |
includes in the view descriptor all columns that were specified in the access descriptor and that were not dropped.
can be either the DBMS
column name or the positional equivalent from the LIST statement.
The positional equivalent is the number that represents where the
column is located in the access descriptor on which the view is based.
For example, to select the first three columns, submit this statement: select
1 2 3;
If the column name contains lowercase characters, special characters, or national characters, enclose the name in quotation marks.
SELECT statements are cumulative within a view creation. For example, columns 1, 5, and 6 are selected if you submit these SELECT statements:
select 1;
select 5 6;