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.
Specific Name
Restrictions on the Owner Name

Restrictions on the Owner Name

When you declare a specific name, the owner must be the same authorization identifier that qualifies the function name or procedure name of the UDR that you create. That is, whether or not you specify the owner name to qualify either the UDR name or the specific name or both, the names of the owner must match.

When you specify no owner name in the DDL statement that creates a UDR, HCL OneDB™ uses the login name of the user who creates the UDR. Therefore, if you specify the owner name in one location and not the other, the owner name that you specify must match your user ID.