Skip to main content

DISTRIBUTED

DISTRIBUTED(recordset [, expression ] )

recordsetThe set of distributed records.
expressionOptional. An expression that specifies how the recordset is distributed.
Return:DISTRIBUTED returns a set of records.

The DISTRIBUTED function is a compiler directive indicating that the records from the recordset are already distributed across the nodes of the Data Refinery based on the specified expression. Records for which the expression evaluates the same are on the same node.

If the expression is omitted, the function just suppresses a warning that is sometimes generated that the recordset hasn't been distributed

Example:

MySet := DISTRIBUTED(Person,HASH32(Person.per_ssn));
        //all people with the same SSN are already on the same node

See Also: HASH32, DISTRIBUTE