The ACCESS Procedure for Relational Databases

SELECT Statement

Selects DBMS columns for the view descriptor

Applies to:	view descriptor
Interaction:	RESET

SELECT ALL |<'>column-identifier-1<'> <...<'>column-identifier-n <'>>;

ALL

includes in the view descriptor all columns that were defined in the access descriptor and that were not dropped.

column-identifier

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.

Details

The SELECT statement is required. The SELECT statement specifies which DBMS columns in an access descriptor to include in a view descriptor.

SELECT statements are cumulative within a view creation. That is, if you submit the following SELECT statements, columns 1, 5, and 6 are selected:

select 1;
select 5 6;

To clear your current selections when creating a view descriptor, use the RESET ALL statement.

Top of Page