The following are composite-table-related functions that handle computations over composite tables that are unique in esProc.
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 |
||
Merge a sequence of composite table cursors |
||
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 and write it to another composite table file |
||
Restore a composite table file to the previous state when update error happens |
||
Join up multiple pseudo tables |
||
Ø 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 |
|
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 |
||
Create a new composite table file using the data structure of an existing composite table |
||
Segment an entity/in-memory table and return the cursor of a specified segment |
||
Synchronously segment an entity table according to a multicursor and return a multicursor |
||
Get a cursor based on a pseudo table |
||
Delete specified record(s) from an entity table |
||
Delete one or more specified records from 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 |
||
Find the record(s) according to the specified primary key value(s) from the base table |
||
Group records of a pseudo table by comparing the grouping field in each with its next neighbor |
||
Group records in a pseudo table |
||
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/multi-zone 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 |
||
Ø 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 |
||
Rename fields in an entity table or distributed table |
||
Select records from a pseudo table according to a specified condition and return the original pseudo table |
||
Update records in an entity table |
||
Update records in a pseudo table |
||
Return an attached table’s records as a sub table sequence |
||