FROM

FROM

Top  Previous  Next

 

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.nois 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.