ACCESS Procedure Reference

SELECT Statement (Optional)

Selects the items in the access descriptor that are to be included in the view descriptor.

Applies to:

view descriptors only

Syntax

SELECT ALL|variable-identifier <...variable-identifier-n>;

Details

The SELECT statement selects the database items in the access descriptor that you want included in the view descriptor. You might include as many items as you want in one SELECT statement.

You can use one or more of the following in the SELECT statement:

ALL: includes in the view descriptor all of the items defined in the access descriptor that were not dropped.

variable-identifier can be one of the following:

the current SAS name
the positional equivalent, which is the number that represents the item, as specified in the LIST statement
the SYSTEM 2000 C-number of the database item.

For example, if you want to select the first three items, submit the following statement:

select 1 2 3;

SELECT statements are cumulative within the same view creation. That is, if you submit the following two SELECT statements, items 1, 5, and 6 are selected (not just items 5 and 6):

select 1;
select 5 6;

To clear all of the current selections when creating a view descriptor, you can use the RESET ALL statement, and use another SELECT statement to select new items.

Note: If you select a record in a SELECT statement, all items in that record are selected. [cautionend]

Top of Page