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.
Database Object Name
Routine Overloading and Routine Signatures
Specifying an Existing UDR

Specifying an Existing UDR

To reference an existing UDR by a name that does not uniquely identify the UDR, you must also specify the parameter data types after the UDR name, in the same order that they were declared when the UDR was created. HCL OneDB™ then uses routine resolution rules to identify the instance of the UDR to alter, drop, or execute. As an alternative, you can specify its specific name, if one was declared when the UDR was created. Specific names are described in the section Specific Name. For more details of routine resolution, see Comparing Arguments to the Parameter List, and HCL OneDB User-Defined Routines and Data Types Developer's Guide.