FROM

The FROM keyword specifies the select list to be used as a source of record ids for processing by the query.

Format

FROM list.no | NONE

where

list.no

is the select list number (0 to 10) to be used.

If the FROM keyword is not present, the query processor will automatically use the default list, list 0, if it is active. Otherwise, all records in the file are processed.

Use of FROM NONE instructs the query processor to ignore the default select list.

Example

LIST STOCK FROM 4

This command lists items from the STOCK file using select list 4 as the source of record ids to be processed.