WebSphere Message Brokers
File: ak19550_
Writer: Bill Oppenheimer

Reference topic

This build: July 31, 2007 21:32:57

ESQL functions: reference material, organized by function type

The following table summarizes the functions 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
Broker 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, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:32:57

ak19550_ This topic's URL is: