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

Thanks,
Kamesh.

No create replace option in DB2 , let me know what U try to do

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.

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

Hi,

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

Thanks,
Kamesh.