ESQL functions: reference material, organized by function type

A table summarizing the functions that are available in ESQL, and what they do.

CATEGORY FUNCTIONS RELATED KEYWORDS
Variable manipulation
Manipulation of all sources of variables
Basic manipulation of all types of variable
  • 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
  • FROM, AS, ITEM, THE, SUM, COUNT, MAX, MIN
Information relating to message trees or subtrees  
Processing Lists  
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
Boolean evaluation for conditional statements
Functions that return a Boolean value SYMMETRIC, ASYMMETRIC, AND
Database interaction
Actions on tables
  • FROM, AS, ITEM, THE, SUM, COUNT, MAX, MIN
Results of actions  
Related concepts
ESQL overview
Related tasks
Developing ESQL
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2009Copyright IBM Corporation 1999, 2009.
Last updated : 2009-01-07 15:22:26

ak19550_