esProc offers loop functions that perform loop operations.
Ø A.(x,…) |
Compute an expression with each member of a sequence, and return the results |
Ø A.avg() |
Compute the average value of the non-null members in a sequence |
Ø A.avg(x) |
Compute x with each member of the sequence and then compute the average value of the non-null members of the new sequence |
Ø A.calc() |
Compute an expression with one or more specified records and return the results |
Ø A.conj() |
Compute concatenation of all sequence-type members in a sequence |
Count the number of non-null members in a sequence |
|
Compute x with each member of the sequence and then count the number of non-null sequence members of the new sequence |
|
Ø A.diff() |
Compute difference between all sequence members of a sequence |
Compute x with each member of the sequence whose members are sequences, and then compute difference between members of the new sequence |
|
Ø A.f(x) |
The common rules of loop functions |
Find a record according to its primary key value |
|
Ø A.ifn() |
Get the first non-null member from a sequence |
Ø A.ifn(x) |
Compute x with each member of the sequence and return the first non-null member of the new sequence |
Compute intersection of the sequence-type members of a sequence |
|
Compute x with each member of the sequence whose members are sequences, and then compute intersection of members of the new sequence |
|
Perform interative loop on a record sequence and return the result of the last calculation of a given expression |
|
Ø A.max() |
Compute the maximum value of all the non-null members in a sequence |
Ø A.max(x) |
Compute x with each member of the sequence and then find the maximum value of the members of the new sequence |
Ø A.maxp() |
Return the member that makes the maximum value for the expression |
Ø A.min() |
Compute the minimum value of all the non-null members in a sequence |
Ø A.min(x) |
Compute x with each member of the sequence and then find the minimum value of the members of the new sequence |
Ø A.minp() |
Return the member that makes the minimum value of the expression |
Ø A.nvl() |
Get the first non-null member that isn’t double quoted from an integer sequence |
Find the sequence number of a record by its primary key |
|
Ø A.pmax() |
Return the sequence numbers of members with the maximum value in a sequence |
Ø A.pmin() |
Return the sequence numbers of members with the minimum value in a sequence |
Return the sequence number of the interval in which the parameter falls |
|
Return the sequence numbers of members that satisfy the query criterion |
|
Return the sequence numbers of the sorted members in the original sequence |
|
Ø A.ptop() |
Get sequence numbers of top n smallest members of the sequence |
Compute the ranking of a specified value in a sequence |
|
Get the ranking of a specified value in a computed sequence |
|
Compute the ranking of each member in a sequence |
|
Get the rankings of members of sequence A.(x) |
|
Compute one or more expressions with each member in a sequence and return the modified sequence |
|
Return members that make the value of the expression true |
|
Ø A.sort() |
Generate a new sequence by sorting the members of a sequence |
Ø A.sum() |
Compute the sum of members of a sequence |
Ø A.sum(x) |
Compute x with each member of the sequence and compute the sum of the members of the new sequence |
Ø A.top() |
Get the n smallest members from a sequence |
Compute the union of all sequence-type members in a sequence |
|
Compute x with each member of the sequence whose members are sequences, and then compute union of members of the new sequence |
|
Generate a new sequence by uniting and rearranging distinct members in each of a sequence’s sub-sequences |
|
Calculate an expression with each member of every sub-sequence of a sequence to generate a new sequence by uniting and rearranging distinct members in each of the resulting sub-sequences |
|
Ø cum() |
An iterative loop to get a cumulative value over records in which one of its fields has same values |
Get information about base members at a superior level in a multilayer loop function |
|
An iterative loop for calculating an expression |
|
Ø k.row() |
Find one or more records according to specified key value(s) |
Ø n.f(x) |
Perform a loop operation by declaring an integer loop variable |
Ø r.(x) |
Compute an expression with a record and return the result |
Ø r.run() |
Compute an expression based on a record and return the modified record |
Ø rank() |
An iterative loop for numbering records according to the values of certain fields |
Ø ranki() |
An iterative loop for numbering records according to the values of certain fields |
Ø seq() |
An iterative loop for numbering records in which a certain field contains same values |
Introduce the common rules of expressions in a loop function |