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.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Data TypeThe Data Type segment specifies the data type of a column, of a component of a collection, of a field within a ROW type, of a routine parameter, or of a value returned by an expression or by a cast function. Use this segment whenever you see a reference to a data type in a syntax diagram.
Built-In Data Types
Character Data Types
LVARCHAR Data Type

LVARCHAR Data Type

The LVARCHAR type of HCL OneDB™ can store up to 32,739 bytes of text, but if you specify no size in an LVARCHAR data type declaration, the default length is 2,048 bytes. LVARCHAR is a built-in opaque data type. Unlike most of the built-in opaque types, LVARCHAR column values can be accessed in a database of a non-local HCL OneDB instance in a distributed query or other DML operations, and LVARCHAR can be the data type of a parameter or of a returned value of a UDR that accesses data outside the local database.

HCL OneDB uses the LVARCHAR data type in cross-server I/O operations on opaque data types. In this context, the maximum size of the LVARCHAR data value is limited only by the operating system.

Light scans during query execution are not supported on tables that include LVARCHAR columns, unless the BATCHEDREAD_TABLE configuration parameter (or the BATCHEDREAD_TABLE session environment option) is set to 1.