This reference guide includes all functions used in esProc. Each function reference consists of all or most of these items – Description, Syntax, Note, Parameters, Options, Return value, and Example.
Note: Below lists the commonly used prefixes and parameters symbols in this Reference. These characters have the listed meanings but may also take other denotations. So you need to reference the specific description when using a function.
Prefix |
Description |
A |
Sequence |
CS |
A sequence of cursors |
G |
Canvas |
P |
Record sequence |
T |
Table sequence, composite table, in-memory table, pseudo table, cluster table or cluster in-memory table |
ch |
Channel |
cs |
Cursor |
db |
Data source connection |
f |
Data file object, bin file object, composite table file object, homo-name files group object |
mcs |
Multicursor |
r |
Record |
s |
String |
xo |
Excel object |
Parameter |
Description |
C |
Column name |
F |
Field name |
K |
Key |
G |
Name of to-be-aggregated field |
b |
Block size |
cs |
Character set |
fn |
File object |
i |
Positive integer or position |
n |
Positive integer, number of segments, number of subcursors, number of parallel threads or index length |
p |
Password |
s |
Time, separator or string |
t |
Date |
w |
Filter expression |
x |
Computing expression |
y |
Aggregate expression |