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, 2009Copyright IBM Corporation 1999, 2009.
Last updated : 2009-01-07 15:22:20

ak05587_