TO (Selection verbs)

TO   (Selection verbs)

Top  Previous  Next

 

The TO keyword used in a SELECT, SSELECT or SEARCH command specifies the select list to be created.

 

 

Format

 

TO list.no

 

where

 

list.nois the select list number (0 to 10) to be created.

 

 

If the TO keyword is not present, the default list, list 0, will be created.

 

 

Example

 

SELECT STOCK WITH COST > 100 TO 4

 

This command builds a list of records in the STOCK file with the COST field greater than 100, placing the resultant record ids in select list 4.