esProc provides cursor functions that handle cursor-related computations.
Generate a cursor from a sequence |
|
Generate a multicursor from a sequence |
|
Generate a multicursor segmented synchronously as an existing multicursor using a specified sequence |
|
Concatenate members of a cursor sequence and return result as a cursor |
|
Generate a multicursor based on a sequence of cursors |
|
Merge members of a sequence of cursors |
|
Compute a given expression over each member in a channel |
|
Split each of the records in a channel, union the members and return the resulting union as a channel |
|
Add fields to records in a channel |
|
Fetch and store the existing data in a channel |
|
Perform foreign-key-style association on a channel |
|
Group records in a channel by comparing each one with its neighbor(s) and return a channel |
|
Group records in a channel and push them respectively into a sequence of channels |
|
Group records in a channel |
|
Group records in a channel and return a channel |
|
Ø ch.id() |
Generate a channel consisting of values of one or more fields |
Perform iterative loop on record sequences in a channel and return the result of the last calculation of a given expression |
|
A foreign-key-style join between a channel and a record sequence |
|
Join up a channel and a bin file/an entity table according to the foreign key |
|
Ø ch.new() |
Return a channel with newly-computed field values for its records |
Get new values for the fields of records in a channel and update them into the channel |
|
Push data in a channel into another channel |
|
Get result of an operation performed in a channel |
|
Ø ch.run() |
Compute an expression against each of the records in a channel and return the channel with new field values |
Return a channel with records that meet the given condition |
|
Send records in a channel that can’t meet the given condition into another channel |
|
Sort records in a channel |
|
Switch the values of a reference field in a channel between the corresponding primary key values and the referenced records, or, sometimes switch between them in a reverse direction |
|
Perform aggregation over records in a channel |
|
Create a channel |
|
Create a channel and push data in a specified cursor into it |
|
Create a channel and push data in another channel into it |
|
Ø cs.(x) |
Compute an expression over each member in the cursor and return results as a cursor |
Close a cursor |
|
Split each of the records in a cursor, union the members and return the original cursor |
|
Add one or more fields to a cursor |
|
Fetch one or more records from a cursor |
|
Perform foreign-key-style association on a cursor |
|
Group cursor records by comparing only adjacent records and return the original cursor |
|
Group records of a given cursor by comparing each with its neighbors, perform aggregation over each group and return the original cursor |
|
Group records in a cursor and push them respectively into a sequence of channels |
|
Group records of a cursor and write the grouped subsets to a sequence of bin files |
|
Group records in a cursor |
|
Group records in a cursor and return result as a cursor |
|
Ø cs.id() |
Generate a sequence consisting of values of fields in a given cursor |
Perform the iterative loop on record sequences in a cursor and return the result of the last calculation of a given expression |
|
A foreign-key-style join between a cursor and a table sequence/record sequence |
|
Join up a cursor and a segmentable bin file according the foreign key |
|
Generate a multicursor based on one cursor |
|
Ø cs.new() |
Return a cursor with newly-computed field values for its records |
Compute new cursor field values to update them into the original cursor |
|
Create association between cursors, or cursor and record sequence through the join key |
|
Push data in a cursor into a channel |
|
Rename a returned field of a cursor |
|
Match the string members in a cursor with a regular expression |
|
Reset a cursor by moving it back to the beginning |
|
Ø cs.run() |
Compute one or more expressions against each of the records in a cursor and return the modified cursor |
Write records that not satisfy the specified expression into a bin file |
|
Return records meeting the given condition from a cursor |
|
Send records in a cursor that can’t meet the given condition into a channel |
|
Skip records while fetching records from a database cursor, and return the number of skipped records |
|
Sort data in a cursor |
|
Replace values of a specified field in a cursor with the referencing field values of the corresponding record in another table |
|
Perform aggregation over records in a cursor |
|
Create a database cursor by executing an SQL statement |
|
Execute a SQL statement through a specified database connection |
|
Update a database table according to a cursor |
|
Create a cursor based on a file |
|
Create a multicursor based on a file |
|
Retrieve data from a cursor and write it to a file |
|
Create a cursor based on an ordered file and return it |
|
Ø joinx() |
Join table sequences retrieved from a series of cursors |
Merge subcursors in a multicursor into a unicursor or a new multicursor with a smaller number of parallel subcursors |
|
Get records from a multicursor |
|
Ø xjoinx() |
Perform cross join over unicursors or table sequences |