SELECT Statement

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

Type: Optional statement
Applies to: view descriptor

Syntax

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

Required Arguments

If the access descriptor contains segments representing more than one path, using ALL creates an invalid view descriptor.

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 creates an invalid view descriptor.

item-name

specifies the name of the item that 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 that 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.

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.