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

    Unanswered: DB2 Object types

    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!

  2. #2
    Join Date
    Apr 2010
    Posts
    10
    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
    Location
    USA
    Posts
    5,737
    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
    Posts
    3
    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
  •