Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Posts
    40

    Unanswered: Create Schema Equivalent

    Is CREATE SCHEMA in DB2 is equivalent to CREATE OR REPLACE PACKAGE BODY in Oracle?.

    Thanks,
    Kamesh.

  2. #2
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    No create replace option in DB2 , let me know what U try to do
    Lekharaju Ennam
    Certified Oracle8i & DB UDB DBA
    Florida A&M University

  3. #3
    Join Date
    Jul 2004
    Posts
    40
    I m basically trying to create a oracle equivalent package in DB2. Is this possible to create the same using CREATE SCHEMA stmt..?

    Thanks
    Kamesh.

  4. #4
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    in DB2 package mean different , compiled sql statements stored in it , that is package in DB2.

    But in Oracle combinations of stored procedures & functions


    if you want to convert Oracle package into DB2 , create stored procedures & functions seperatly by using DB2 Development Centre ( for DB2 UDB V8 ) , Db2 stored procedure builder ( in DB2 UDB V7)


    from which version or environment of Oracle R U migrating , what is your DB2 version & environment.

    based on it I can give some tips & thoughts


    Thank You
    Lekharaju Ennam
    Certified Oracle8i & DB UDB DBA
    Florida A&M University

  5. #5
    Join Date
    Jul 2004
    Posts
    40

    Hi Lekharaju Ennam!!!

    Hi,

    I m trying to convert ORACEL 9i to DB2 UDB 8.1.

    Thanks,
    Kamesh.

Posting Permissions

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