Literal Collection

HCL OneDB™ supports expressions that are literal representations of the values of built-in or user-defined collection data types. The following examples show literal collections as expressions:
INSERT INTO tab_a (set_col) VALUES ("SET{6, 9, 3, 12, 4}");

INSERT INTO TABLE(a_set) VALUES (9765);

UPDATE table1 SET set_col = "LIST{3}";

SELECT set_col FROM table1
   WHERE SET{17} IN (set_col);

For more information, see Literal Collection. For the syntax of element values, see Collection Constructors.