CAS 6


random
- Relational

Summary

Generate a random sample of records

Examples

random 5 
random 1000000 CURBAL 
random 5 (STATE in 'VA')
random 1000000 CURBAL (STATE in 'VA')  
 random 5 STATE 
random 1000000 CURBAL STATE 

Syntax

random NumField (Weight) (SelectionStatement∣Grouping)

Right Arguments

Name Data Type Input Type Description Optional Default
NumField Numeric Field Number of records Yes
Weight Numeric Field Weighting Factor Yes
SelectionStatement Boolean Field Expression to select records that will be applied to the calculation. Yes 1
Grouping Text Field Grouping Field Yes

Result

Type: Boolean





Build 6.0.624