The SELECT statement
can take one of the following arguments:
ALL
includes in the view descriptor all the DBMS columns that were defined in the access
descriptor excluding dropped columns.
column-identifier
can be either the CA-Datacom/DB
field name or the positional equivalent from the LIST statement, which is the number that
represents the
column's place in the access descriptor on which the view is based. For example, to select
the first three columns, submit the following statement:
select 1 2 3;
If the CA-Datacom/DB field name contains special characters or national characters,
enclose the name in quotation
marks. You can select as many DBMS columns as you want in one SELECT statement.
SELECT statements are cumulative within the same view creation. That is, if you submit
the following two SELECT statements, columns 1,
5, and 6 are selected, not just columns 5 and 6:
select 1;
select 5 6;
To clear all your current selections when creating a view descriptor, use the RESET
ALL statement; you can then use another SELECT statement
to select new columns.