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.
(explicit id fbcl005) fbcl005 (explicit id fbcl006) fbcl006 (explicit id fbcl007) fbcl007

FRAGMENT BY clause for tables

[ WITH ROWIDS ]
{ FRAGMENT | PARTITION } BY
{ ROUND ROBIN { IN dbspace | PARTITION partition IN dbspace } | EXPRESSION <Expression Fragment Clause> [] | RANGE ( fragment_key ) <Interval Fragment Clause> [] | LIST ( fragment_key ) <List Fragment Clause> [] }
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.

1 See ids_sqs_2095.html#ids_sqs_2095
2 See List fragment clause
3 See Expression Fragment Clause