Set-valued attributes in informix

Hallo, does "object-relational" informix in some way supports set-valued component or association objects within a type definition? For example, if I have something like CREATE EMPLOYEE AS ... can I then define CREATE DEPARTMENT AS (Name VARCHAR(30), Employees REF(EMPLOYEE) ARRAY[] (or Employees SET(EMPLOYEE)) ... ) to express the 1:many relationship between a department and its employees? (This would correspond to the current SQL3 standard of user defined types) Any comments or pointer are welcome Thanks Robert Dipl. Math. Robert Mueller Tel.: (+49) 341 97 32227 Institut fuer Informatik Fax.: (+49) 341 97 32209 (secretary) Universitaet Leipzig, Augustusplatz 10/11, 04109 Leipzig , Germany email: mueller@informatik.uni-leipzig.de Web: http://www.informatik.uni-leipzig.de/~mueller/

Yes. RTFineM. Sets, collections, lists, etc. Art S. Kagel Robert Mueller wrote: > > Hallo, > > does "object-relational" informix in some way supports set-valued > component or association objects within a type definition? For example, if > I have something like > > CREATE EMPLOYEE AS ... > > can I then define > > CREATE DEPARTMENT AS > (Name VARCHAR(30), > Employees REF(EMPLOYEE) ARRAY[] (or Employees SET(EMPLOYEE)) > ... > ) > > to express the 1:many relationship between a department and its employees? > (This would correspond to the current SQL3 standard of user defined types) > > Any comments or pointer are welcome > Thanks > Robert > > Dipl. Math. Robert Mueller Tel.: (+49) 341 97 32227 > Institut fuer Informatik Fax.: (+49) 341 97 32209 (secretary) > Universitaet Leipzig, Augustusplatz 10/11, 04109 Leipzig , Germany > email: mueller@informatik.uni-leipzig.de > Web: http://www.informatik.uni-leipzig.de/~mueller/