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.
Routine Parameter List
Subset of SQL Data Types

Subset of SQL Data Types

Serial and large-object data types are not valid as parameters. A UDR can declare a parameter of any other data type defined in the database, including any built-in data types except BIGSERIAL, BLOB, BYTE, CLOB, SERIAL, SERIAL8, or TEXT.

On HCL OneDB™, a parameter can also be a complex data type or a UDT, but complex data types are not valid for parameters of external UDRs written in the Java™ language.

For information about the data types of HCL OneDB that are valid as parameters or return values of routines that access tables or views outside the local database, see Returning a value from another database.