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.
Owner nameThe owner name specifies the owner of a database object. Use this segment whenever you see a reference to Owner Name in a syntax diagram.
Default Owner Names

Default Owner Names

If you create a database object without explicitly specifying an owner name in a database that is not ANSI-compliant, your authorization identifier (as the default owner of the object) is stored in the system catalog of the database as if you had specified your authorization identifier within quotation marks (that is, preserving the lettercase).

If you create a database object without explicitly specifying an owner name in a database that is ANSI-compliant, any lowercase letters in your authorization identifier (as the default owner of the object) are stored in the system catalog of the database in uppercase characters, unless the ANSIOWNER environment variable was set to 1 before the database server was initialized. If ANSIOWNER was set to 1, however, the database stores the default owner of the object as your authorization identifier, with its lettercase preserved.