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.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
ALTER FRAGMENT statementUse the ALTER FRAGMENT statement to change the distribution strategy or the storage location of an existing table or index. This statement is an extension to the ANSI/ISO standard for the SQL language.
ADD ClauseUse the ADD clause to add another fragment to a list of fragments of an existing table or index.
Adding a New Named Fragment to a Round-Robin Distribution Scheme

Adding a New Named Fragment to a Round-Robin Distribution Scheme

In HCL OneDB™, you can add a named fragment to an existing round-robin distribution scheme. The name must be unique within the distribution among fragments of the same dbspace. The following example specifies the same original round-robin fragmentation definition as in the previous section:

CREATE TABLE book (col1 INT, col2 INT) 
   FRAGMENT BY ROUND ROBIN IN dbsp1, dbsp4;

To add a new named fragment, you can use the ADD clause, as in the following example:

ALTER FRAGMENT ON TABLE book 
   ADD PARTITION chapter3 IN dbsp1;

The new distribution uses dbsp1, dbsp4, and chapter3 as storage locations for a 3-part round-robin fragmentation scheme. The records in the fragment chapter3 are stored in separately in the dbspace dbsp1 from the records in the first fragment, which is identified only by the dbspace name: dbsp1.