The SET data type
The SET IBM® Informix® data type is a collection type that stores non-ordered unique elements of a specific base type. Unlike the LIST type, the elements of a LIST have no ordinal positions. Elements cannot be duplicated.
Genero BDL does not support the IBM Informix SET data type:
- It is not possible to define BDL variables with the SET type.
- The static SQL syntax does not support collection-related syntax elements:
- DDL statements like CREATE TABLE cannot use the SET keyword for column types,
- The collection-derived notation
TABLE()
is not allowed, - The
SET { }
literal syntax is not allowed. - The
value IN identifier
syntax is not allowed.
- The fgldbsch schema extractor will report an invalid data type if you try to get the schema for a table with a SET column.