Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2008
    Posts
    3

    Unanswered: Convert Oracle Syntax to DB2

    Hi, everyone,
    i'm new in db2 and i have a job to convert my stored procedure from oracle to db2, anyone know about the tutorial that i can read for reference?

    And do you know the function in DB2 like DBMS_UTILITY.uncl_array(oracle) ?

    Thank you

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    DB2 V9.5 is a lot easier to convert from Oracle to DB2. What realease do you have of DB2?

    If you want an alternative for an Oracle function, please explain in detail what it does.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2008
    Posts
    3
    Hi, thanks for the reply
    i'm use DB2 V9.5
    for this time i want to know the function in db2 that same with DBMS_UTILITY.uncl_array (oracle)

    thanks before

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Please explain in detail what DBMS_UTILITY.uncl_array does and how it works.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Jun 2008
    Posts
    3
    here is some explaination

    DBMS_UTILITY.UNCL_ARRAY
    This PL/SQL table type is used to store lists of strings in the format:

    "USER"."NAME."COLUMN"@LINK
    You can use the array to store any strings you want up to the length determined in the following TABLE type statement:

    TYPE DBMS_UTILITY.UNCL_ARRAY IS
    TABLE OF VARCHAR2(227) INDEX BY BINARY_INTEGER;

  6. #6
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by heinzk
    i have a job to convert my stored procedure from oracle to db2, anyone know about the tutorial that i can read for reference?
    There is a "Redbook" about converting from Oracle to DB2, reference number SG24-7048. See http://www.redbooks.ibm.com/redbooks/pdfs/sg247048.pdf
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by Peter.Vanroose
    There is a "Redbook" about converting from Oracle to DB2, reference number SG24-7048. See http://www.redbooks.ibm.com/redbooks/pdfs/sg247048.pdf
    That manual is based on DB2 V9.1. I believe that DB2 has added some kind of array support in V9.5. I would google it.

    As I said previously, 9.5 has a lot of Oracle compatibility features.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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