Home
Designing databasesThe first step in creating a relational database is to construct a data model, which is a precise, complete definition of the data you want to store. After you prepare your data model, you must implement it as a database and tables. To implement your data model, you first select a data type for each column and then you create a database and tables and populate the tables with data. You can also implement fragmentation strategies and control access to your data.
Designing and Implementing a DatabaseThe HCL OneDB™ Database Design and Implementation Guide provides information to help you design, implement, and manage your HCL® OneDB® databases. It includes data models that illustrate different approaches to database design and shows you how to use structured query language (SQL) to implement and manage your databases.
Object-relational databases
Create and use extended data types in HCL OneDB™
Complex data types
Collection data types
Restrictions on collections

Restrictions on collections

You cannot use any of the following data types as the element type of a collection:

TEXT
BYTE
SERIAL
SERIAL8
BIGSERIAL

You cannot use a CREATE INDEX statement to create an index on collection, nor can you create a functional index for a collection column.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.