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.
DETACH ClauseUse the DETACH clause of the ALTER FRAGMENT ON TABLE statement to detach a table fragment from a storage distribution scheme and place the contents into a new nonfragmented table.
Detach from a Protected TableIf a successfully executed DETACH clause specifies a table that is protected by a security policy, the database server creates a new table that is protected by the same security policy.

Detach from a Protected Table

If a successfully executed DETACH clause specifies a table that is protected by a security policy, the database server creates a new table that is protected by the same security policy.

If the original table has both row-level and column-level protection,

the new table has the same IDSSECURITYLABEL column, and the same label, for row-level security,
and the same set of protected columns secured by the same labels as the original table for column-level protection.

For tables with row-level protection, the IDSSECURITYLABEL column has a NOT NULL constraint by default. Only a user who holds the DBSECADM role can reference a protected table in the ALTER FRAGMENT statement.