Functions for Associative Operations

Read(454) Label: associative operation,

  The following are functions that deal with esProc associative operations.

Ø  A.derive()

Add one or more fields to a table sequence/record sequence

Ø  A.group(xi,…)

Perform equi-grouping according to one or more fields or expressions

Ø  A.group(x:F,…;y:G,…)

Group a sequence and then perform aggregate operations

Ø  A.groups() 

Group a table sequence and then get the aggregating result cumulatively

Ø  A.id()

Perform merging and sorting, then the distinct operation on a sequence, and return the result of distinct

Ø  A.join()

A foreign-key-style join between table sequences/record sequences, or a table sequence and a record sequence

Ø  A.merge()

Merge multiple table sequences/record sequences

Ø  A.new(xi:Fi,…)

Generate a new table sequence/record sequence, whose field values are computed from the field values of a table sequence/record sequence

Ø  A.news(X;xi:Fi,…)

Compute field values based on a table sequence/record sequence, and concatenate them to generate a new one

Ø  A.pivot()

Perform row-to-column transposition for a sequence

Ø  A.switch()

Switch the values of the reference field between the corresponding primary key values and the referenced records, or, sometimes switch between them in a reverse direction

Ø  E.penum()

Judge to which enum group of a record sequence a field value or an expression belongs, and return the serial number(s) of the group(s) satisfying the grouping criterion

Ø  P.align()

Align the records of a record sequence to another sequence or record sequence by the relational fields and then sort them, so as to group the record sequence

Ø  P.derive()

Generate a table sequence according to a record sequence

Ø  P.enum()

Generate a new record sequence by performing enumeration grouping on a record sequence according to another record sequence of conditional expressions

Ø  P.nodes()

Find the children nodes of a specified record

Ø  join()

Join multiple sequences together

Ø  r.prior()

Among the records, query fields referred by the foreign key recursively

Ø  xjoin()

Perform a cross join on multiple sequences

Ø  xjoinx()

Perform cross join over single cursors or table sequences