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™.
CREATE TABLE statementUse the CREATE TABLE statement to create a new permanent table in the current database.
Storage optionsUse the FRAGMENT BY clause, PUT clause, and EXTENT size options of the CREATE TABLE statement to specify the storage location, distribution scheme, and extent size for the table. Use the FRAGMENT BY clause, PUT clause, EXTENT size options, and COMPRESSED option of the CREATE TABLE statement to specify the storage location, the distribution scheme, the extent size for the table, and whether the table is enabled for the automatic compression of large amounts of new row data.
FRAGMENT BY clauseUse the FRAGMENT BY clause to create a fragmented table and to specify its storage distribution scheme. The keywords PARTITION BY are a synonym for FRAGMENT BY.

FRAGMENT BY clause

Use the FRAGMENT BY clause to create a fragmented table and to specify its storage distribution scheme. The keywords PARTITION BY are a synonym for FRAGMENT BY.

This syntax fragment is part of the Storage options.

FRAGMENT BY clause for tables

Notes:


Element	Description	Restrictions	Syntax
column	Column to which to apply the fragmentation strategy	Must be a column within the table	Identifier
dbspace	Dbspace to store the table fragment	You can specify no more than 2,048 dbspaces. All dbspaces that store the fragments must have the same page size.	Identifier
fragment _key	Cast, column, or function expression on a table column. This is the expression on which the table is fragmented.	Columns must be from the current table only	Expression
partition	Name declared here for a fragment	Must be unique among the names of fragments of the table	Identifier

When you fragment a table, the IN keyword is followed by the name of the storage space where a table fragment is to be stored.

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.