Functions

Read(3456) Label: esproc functions,

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