Literal Collection

Informix® 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);