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 SECURITY LABEL COMPONENT statementUse the ALTER SECURITY LABEL COMPONENT statement to add one or more new elements to an existing security label component in the current database. This statement is an extension to the ANSI/ISO standard for SQL.
The ADD SET Clause

The ADD SET Clause

A security label component of type SET is an unordered set of no more than 64 elements. The order in which the elements of a SET component are declared is not significant. The set of elements of the array and their comma separators must be enclosed between a pair of braces ( { ... } ) symbols. The same new element cannot be declared more than once in the same ADD SET clause.

The following example defines a type SET security label component called departments that is an unordered set of three elements, called Marketing, HR, and Finance, which the ALTER SECURITY LABEL COMPONENT statement modifies by adding three new elements called Training , QA, and Security:

CREATE SECURITY LABEL COMPONENT departments 
   SET { 'Marketing', 'HR', 'Finance' };

ALTER SECURITY LABEL COMPONENT departments 
   ADD SET { 'Training', 'QA', 'Security' };

Unlike ADD ARRAY or ADD TREE specifications, ADD SET operations of ALTER SECURITY LABEL COMPONENT do not create "greater than" or "less than" data-sensitivity relationships among the new and existing elements of the redefined component, because the elements of a type SET component have no implicit order of data sensitivity.