Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
The database server
Client/server communicationThese topics explain the concepts and terms that you must understand in order to configure client/server communication.
Distributed Relational Database Architecture™ (DRDA®) communicationsDRDA is a set of protocols that enables multiple database systems and application programs to work together.
SQL and supported and unsupported data typesWhen using DRDA®, HCL OneDB™ syntax is supported over the common API. When using DRDA® connections, HCL OneDB™ rounds decimal and money values to 32-digit precision for all data retrieval operations on decimal or money data types.

SQL and supported and unsupported data types

When using DRDA®, HCL OneDB™ syntax is supported over the common API. When using DRDA connections, HCL OneDB rounds decimal and money values to 32-digit precision for all data retrieval operations on decimal or money data types.

The following data types are supported over the common API:

BIGINT
BIGSERIAL
BLOB
BOOLEAN
BSON
BYTE
CHAR(32k)
CLOB
DATE
DATETIME
DECIMAL
FLOAT
INT
INT8
INTERVAL
JSON
LVARCHAR(32k)
MONEY
NCHAR(32k)
NVARCHAR(255)
SERIAL
SERIAL8
SMALLFLOAT
SMALLINT
TEXT
VARCHAR(255)

HCL OneDB DATETIME values are mapped to DATE, TIME, or TIMESTAMP values.

The following data types are supported for use with database server host variables:

CHAR
DATE
INT
SMALLINT
VCHAR