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.
Setting ANSIOWNER for an ANSI-Compliant Database

Setting ANSIOWNER for an ANSI-Compliant Database

About this task

The default behavior of an ANSI-compliant database is to replace any lowercase letters with uppercase letters in any owner specification that is not enclosed in quotation marks. You can prevent this by setting the ANSIOWNER environment variable to 1 before the database server is initialized. This preserves whatever lettercase you use when you specify the owner string without quotation marks.