var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB2 Object types
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?)
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
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
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