External Functions and Iterator Functions

In an SPL program, you can use a C or Java™ language external function as an expression in a RETURN statement, provided that the external function is not an iterator function. An iterator function is an external function that returns one or more rows of data (and therefore requires a cursor to execute).

SPL iterator functions must include the RETURN WITH RESUME statement. For information about using an iterator function with a virtual table interface in the FROM clause of a query, see Iterator Functions.