Statements and functions available

CATEGORY FUNCTIONS/ STATEMENTS/ OPERATORS RELATED KEYWORDS
Variable manipulation
Manipulation of all sources of variables
Basic manipulation of all types of variable
  • REFERENCE TO
  • NAME, TYPE, VALUE
  • ENCODING, CCSID, AS
Selective assignment to any variable ELSE, WHEN, THEN, END
Creation of values -
Manipulation of message trees
Assignment to and deletion from a message tree
  • OF, FROM, VALUES, DOMAIN, PARSE
  • TO, AS, FIRSTCHILD, LASTCHILD, PREVIOUSSIBLING, NEXTSIBLING
  • FROM, AS, ITEM, THE, SUM, COUNT, MAX, MIN
Information relating to message trees or subtrees -
Processing repeating fields
  • ALL, ANY, SOME
  • FROM, AS, ITEM, THE, SUM, COUNT, MAX, MIN
Processing based on data type
String processing
Numeric information about strings IN
String conversion -
String manipulation
  • LEADING, TRAILING, BOTH, FROM
  • PLACING, FROM, FOR
  • FROM FOR
Numeric processing
Bitwise operations -
General -
Date time processing
  YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
Reference
  TO, PARENT, FIRSTCHILD, LASTCHILD, PREVIOUSSIBLING, NEXTSIBLING
Flow of control
Conditional statement (within an ESQL node)
  • END
  • END
Exiting an ESQL node USER, EXCEPTION, CATALOGUE, MESSAGE, VALUES
Boolean evaluation for conditional statements
Functions that return a boolean value SYMMETRIC, ASYMMETRIC, AND
Operators used in boolean expressions. -
Broker database interaction
Actions on tables
  • AS, SET, WHERE
  • INTO, VALUES
  • FROM, AS, WHERE
  • FROM, AS, ITEM, THE, SUM, COUNT, MAX, MIN
Results of actions -
Dynamic ESQL
  EVAL statement -
Related concepts
ESQL
Related tasks
Developing ESQL