Description:
------------
Hello

in informix you can use datatype SET, LIST, MULTISET.

We created a table like this
create table "informix".td_action
  (
    act_no serial not null ,
    act_serial integer not null ,
    act_acty_no integer not null ,
    act_mtc_no integer not null ,
    act_period smallint not null ,
    act_minute smallint not null ,
    act_datetime datetime year to fraction(3) not null ,
    act_updatetime datetime year to fraction(3) not null ,
    act_properties  SET(ROW(name VARCHAR(30), value integer) not null) ,
    unique (act_no)
  );

The problem is that we can't get the result of the act_properties.
Maybe you can help us?

Thanks a lot

Best regards
Walter Bernhard