Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Other syntax segmentsThese topics describe syntax segments, which are language elements, such as database object names or optimizer directives, that appear as a subdiagram reference in the syntax diagrams of some SQL or SPL statements.
Return Clause
Limits on Returned Values

Limits on Returned Values

An SPL function can specify more than one data type in the Return clause.

An external function (a function written in the C or the Java™ language) can specify only one data type in the Return clause, but an external function can return more than one row of data if it is an iterator function. For more information, see ITERATOR.