The SELECT statement
specifies which PC file columns in the access descriptor to include
in the view descriptor. This is a required statement, and you can
use it only when you create view descriptors. You cannot use the SELECT
statement when you update a view descriptor.
If you use an editing
statement, such as SELECT, it must follow the CREATE statement when
you create a view descriptor.
The SELECT statement
can take one or more of these arguments:
includes in the view
descriptor all columns that were defined in the access descriptor
and that were not dropped.
can be either the column
name or the positional equivalent from the LIST statement. This is
the number that represents the column's place in the access descriptor
on which the view is based. 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. You can select as many columns
as you want in one SELECT statement.
SELECT statements are
cumulative within the same view creation. Submit these SELECT statements
to select columns 1, 5, and 6.
SELECT 1; SELECT 5 6;
To clear all your selections
when creating a view descriptor, use the RESET ALL statement. You
can use another SELECT statement to select new columns.