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 Specific Name

Restrictions on the Specific Name

In a database that is not ANSI-compliant, specific_id must be unique among routine names within the database. Two UDRs cannot have the same specific_id, even if they have different owners.

In an ANSI-compliant database, the combination owner.specific_id must be unique. That is, the specific name must be unique among UDRs that have the same owner.