WebSphere Message Brokers
File: ak05587_
Writer: John Prowse

Reference topic

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

THE function

The THE function returns the first element of a list.

Syntax

If ListExpression contains one or more elements, THE returns the first element of the list. Otherwise it returns an empty list.

Restrictions

Currently, ListExpression must be a SELECT expression.

Related concepts
ESQL overview
Related tasks
Developing ESQL
Related reference
CARDINALITY function
EXISTS function
SINGULAR function
Syntax diagrams: available types
ESQL list functions
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:17

ak05587_ This topic's URL is: