If an SPL function includes the RETURN statement to return one or more values from another database of the local database server, the parameters and returned values must be of built-in data types. UDRs can also return DISTINCT types whose base types are built-in types, or can be UDTs, but you must explicitly cast the DISTINCT types and UDTs to built-in types. All the UDRs, DISTINCT types, UDTs, and casts must also be defined in all of the participating databases.
Only built-in data types can be returned from tables of other database servers.
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 (IDS).
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]