Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2010

    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!

  2. #2
    Join Date
    Apr 2010
    Hope this may help you :

    DB2 too supports the collections types.

    IBM DB2 9.7 for Linux, UNIX and Windows Information Center

  3. #3
    Join Date
    May 2003
    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

  4. #4
    Join Date
    Apr 2010
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts