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.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE OPAQUE TYPE statementUse the CREATE OPAQUE TYPE statement to create an opaque data type.
Declaring a Name for an Opaque Type

Declaring a Name for an Opaque Type

The name that you declare for an opaque data type is an SQL identifier. When you create an opaque type in a database that is not ANSI-compliant, the name must be unique among the names of data types within the database.

When you create an opaque type in an ANSI-compliant database, owner.type combination must be unique within the database. The owner name is case sensitive. If you do not put quotation marks around the owner name, the name of the opaque-type owner is stored in uppercase letters.