Both full DB2 and DB2 Express C shipped with the Oracle Compatibility Mode, which can be turned on.
Launch the DB2 Administrator command window and issue the following commands.
db2set DB2_COMPATIBILITY_VECTOR=ORA
db2set DB2_DEFERRED_PREPARE_SEMANTICS=YES
Then, restart the database.
db2stop
db2start
Then create a new database and that database is already compatible with Oracle.
db2 CREATE DATABASE DB_Name
No comments:
Post a Comment