SAMPLED

SAMPLED

Top  Previous  Next

 

The SAMPLED selection clause keyword causes only a proportion of records to be selected or displayed.

 

 

Format

 

SAMPLED {n}

 

where

 

nis the sample interval. If n is omitted, this defaults to 10.

 

 

The SAMPLED keyword causes only every n'th record meeting the selection criteria (if any) to be selected or listed.

 

 

Example

 

LIST STOCK WITH QTY > 100 SAMPLED 5

 

This command lists every fifth item found on the STOCK file with a QTY field of over 100.