The following are composite-table-related functions that handle computations over composite tables that are unique in esProc.
Execute DQL query statement |
|
A column in a table, its parent table, or a table above them |
|
Join up a cursor and an entity table by the foreign key |
|
Generate an in-memory table from a cursor |
|
Create association between cursors or record sequences through the join key |
|
Merge a sequence of composite table cursors |
|
Execute DQL query statement |
|
Create DQL connection |
|
Generate a composite table’s base table from a file |
|
Return a file or homo-name files group preceded by corresponding zone table number(s) |
|
Ø f.open() |
Open a composite table’s base table |
Reorganize a composite table file/homo-name files group and write it to a new composite table file/homo-name files group |
|
Restore a composite table file to the previous state when update error happens |
|
Get structure information of a composite table |
|
Ø k.r(T,F) |
Query a specified field in a specific row in an in-memory table |
Find one or more records from an in-memory table according to specified key value(s) |
|
Ø k.sbs() |
Get an integer consisting of certain bytes of a serial byte key |
Copy, move, delete or rename a file |
|
Generate a pseudo table definition object |
|
Alter one or more fields in an entity table |
|
Append records in a cursor to an entity table |
|
Append-write records of a cursor to a pseudo table |
|
Add an attached table to a composite table’s base table |
|
Ø T.C |
Retrieve a specified column from an attached table |
Close a composite table file |
|
Close a pseudo table |
|
Split each record of a pseudo table and concatenate the splitting results |
|
Create a new composite table file using the data structure of an existing composite table |
|
Segment an entity/in-memory table/multizone composite table and return the cursor of a specified segment |
|
Synchronously segment an entity table/in-memory table/multizone composite table according to a multicursor and return a multicursor |
|
Get a cursor based on a pseudo table |
|
Add new fields to a pseudo table |
|
Ø T.f(C) |
Perform an aggregate operation over an attached table’s column |
Find the record(s) according to the specified primary key value(s) from an in-memory table |
|
Get record(s) in an entity table or a multizone composite table according to key value(s) |
|
Perform foreign-key-style association on a pseudo table |
|
Group records of a pseudo table by comparing the grouping field in each with its next neighbor |
|
Group a pseudo table by comparing each record with its next neighbor, perform aggregation over each group, and return a new pseudo table |
|
Group records in a pseudo table |
|
Group records of a pseudo table and write the grouped subsets to a sequence of bin files |
|
Use index to filter an entity table according to the filtering condition |
|
Search for a specified key value in an in-memory table according to the index. |
|
Read in records from an entity table and return them as a table sequence |
|
Get a table sequence based on a pseudo table |
|
Create an index file for an entity table/multizone composite table |
|
Create one or multiple non-primary-key-based indexes for an in-memory table |
|
Create an index for the key of an in-memory table |
|
A foreign-key-style join between a pseudo table and a table sequence/record sequence |
|
Ø T.keys() |
Define the key(s) for an in-memory table |
Set primary key for an in-memory table and in the meantime create index on it |
|
Ø T.len() |
Get the number of records in an in-memory table |
Convert a table sequence to an in-memory table |
|
Generate an in-memory table from an entity table |
|
Get specified field(s) from a composite table according to correspondence between its key values and the fields in a table sequence or a cursor, and return result as a table sequence or a cursor |
|
Get values of specified field(s) according to key values in a table sequence or a cursor, concatenate them and return result as a table sequence or a cursor |
|
Create association between a pseudo table and a cursor/record sequence through the join key |
|
Segment a pseudo table according to the segmentation way of another |
|
Rename fields in an entity table or distributed table |
|
Compute a specified expression on each record of a pseudo table |
|
Select records from a pseudo table according to a specified condition and return the original pseudo table |
|
Write pseudo table records that cannot meet the specified condition into a bin file |
|
Replace values of a specified field in a pseudo table with the corresponding referencing values in another table |
|
Update records in an entity table |
|
Update records in a pseudo table |
|
Return an attached table’s records as a sub table sequence |