ACCESS Procedure

SELECT Statement

Selects DBMS columns for the view descriptor

Interaction:

RESET

Syntax

Required Arguments

Details

Syntax

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

Required Arguments

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.