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 cursor members of a sequence and return result as a multicursor |
|
Generate a multicursor using a sequence of cursors |
|
Generate a multicursor based on a sequence of cursors |
|
Merge members of a sequence of cursors and return a multicursor |
|
Attach a computation to a channel and return the orignal channel |
|
Attach a computation to a channel, which will split each of its records and perform union on the splitting result |
|
Attach a computation that adds one or more fields to a channel and return the original channel |
|
Fetch and store the existing data in a channel |
|
Attach a foreign-key-style association on a channel and return the original channel |
|
Attach an operation of grouping records in a channel by comparing each one with its next and return the original 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 |
|
Attach a foreign-key-style join with a record sequence to a channel and return the original channel |
|
Join up a channel and a bin file/an entity table according to the foreign key |
|
Ø ch.new() |
Attach a computation of getting field values to a channel and return the original channel |
Generate records according to the given condition, concatenate them into a new table sequence and return it to the original channel |
|
Push data in a channel into another channel |
|
Get result of an operation performed in a channel |
|
Ø ch.run() |
Attach a computation that assigns values to a specified field and return the original channel |
Attach a record filtering computation to a channel and return the orignal channel |
|
Send records in a channel that can’t meet the given condition into another channel |
|
Sort records in a channel |
|
Attach a referencing field-based switch operation to a channel and return the original channel |
|
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) |
Attach the action of computing expression to a cursor and return the original cursor |
Close a cursor |
|
Split each of the records in a cursor, union the members and return the original cursor |
|
Generate a multicursor using a unicursor |
|
Attach the action of adding fields to a cursor and return the original cursor |
|
Fetch one or more records from a cursor |
|
Attach foreign key style association to a cursor and return the original cursor |
|
Attach the action of grouping records by comparing only adjacent records to a cursor and return the original cursor |
|
Attach the action of grouping and aggregating records by comparing only adjacent records to a cursor and return the original cursor |
|
Group records in a cursor and push them respectively into a sequence of channels |
|
Attach the grouping record action to a cursor and return the original cursor while writing 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 |
|
Attach foreign key style join with a record sequence to a cursor and return the original cursor |
|
Join up a cursor and a segmentable bin file according the foreign key |
|
Generate a multicursor based on one cursor |
|
Ø cs.new() |
Attach the action of computing new field values to a cursor and return the original cursor |
Generate multiple records based on a record sequence, concatenate them into a new table sequence and return it to the original cursor |
|
Attach the join-key-based association with another cursor or a record sequence to a cursor and return the original cursor |
|
Push data in a cursor into a channel |
|
Rename a returned field of a cursor |
|
Attach the action of matchign string members with a regular expression to a cursor and return the original cursor |
|
Reset a cursor by moving it back to the beginning |
|
Ø cs.run() |
Attach a computation that assigns values to fields in the cursor to the cursor and return the original cursor |
Attach the record filtering action to a cursor and return the original cursor while writing records that not satisfy the specified expression to a bin file |
|
Attach the record filtering action to a cursor and return the original 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 |
|
Attach the action of switching specified field values to the referencing record field values to a cursor and return the original cursor |
|
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 |
|
Sort a data file or a sequence of files and generate a new file |
|
Ø 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 |
|
Ø xjoinx() |
Perform cross join over unicursors or table sequences and return a multicursor |