romeo, thank you for the pointer. I checked it out, and apparently, there is no equivalent to nested tables in DB2.
n-i, you are right, that should have been the correct phrasing in a normal oracle->db2 migration situation. the problem though is that i'm working on a research prototype, and oracle's nested table were exactly what we would have needed... there was a question of whether or not we could implement our prototype on top of some other RDBMS (DB2 for example) without too much hassle (that is, if the schema design remains the same perhaps with minor changes- we dont have to rewrite all our algorithms). That's why I was interested if DB2 supports nested tables as such, and hence the way I phrased my question.
That's why I was interested if DB2 supports nested tables as such, and hence the way I phrased my question.
See, the problem is that very few people attending this discussion know what a "nested table" is. We may be familiar with DB2 but not with Oracle. A concept that Oracle calls "nested tables" may exist in DB2 but most likely it will have a different name. This is why I suggested you stating the problem, not the solution.