Hi!

I'm new to DB2 and looking for the possibility to port some database stuff from Oracle 10g to DB2 Express-C.

I'm having some "collection types of UDT" in oracle and looking for the possibility to create those in DB2 but can't find anything like that.

Example of a collection type I want to create in DB2. (My guess is that collection types doesnt exist in DB2?)

Oracle:
create or replace type NOTES_TYPE as table of NOTE_TYPE;

NOTE_TYPE is a UDT object in Oracle.

Thanks alot in advance!

Hope this may help you :

DB2 too supports the collections types.

IBM DB2 9.7 for Linux, UNIX and Windows Information Center

If you are using DB2 V9.7, you can enable Oracle compatibility mode to make the porting easier. Make sure you have the latest release (9.7.1).

Here is some info:
DB2 9.7: Run Oracle applications on DB2 9.7 for Linux, Unix, and Windows

yes, but the problem is collections of a custom object.. and then return it in a stored procedure..

Have anyone a example of this? I haven't manage to figure out how to do this in DB2. Maybe only possible to have normal collectiontypes without UDT?

Marcus, yes I have seen that, but it require a higher version than DB2 Express-c

Thanks alot!