ACCESS Procedure Reference

SELECT Statement

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

Optional statement
Applies to:	view descriptor

Syntax
Details
Arguments

Syntax

SELECT ALL | item-name | index-number <... item-name-n|index-number-n>;

Details

The SELECT statement selects the items in the access descriptor that are to be included in the view descriptor. Use the SELECT statement only when you are defining view descriptors. You can select as many items as necessary using one SELECT statement.

Arguments

The following list explains the arguments that appear in the SELECT statement:

ALL

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

CAUTION:: If the access descriptor contains segments representing more than one path, using ALL will create an invalid view descriptor.

item-name

specifies the name of the item you want to select to be included in the view descriptor. If you specify a record or group name, all the items in that record or group are selected.

index-number

specifies the index number of the item you want to select. The index number represents the item's place in the access descriptor. You can get the index number of an item using the LIST statement described earlier in this section. If you specify a record or group index number, all the items in that record or group are selected.

Top of Page