As I understand when you set the DB2_COMPABILITY_VECTOR registry
variable it allows execution of PL/SQL in DB2, but this only affects
databases created after the registry cariable is set.

Is there any way to enable all these features for existing databases?

Regards
Odd Bjørn
ErgoGroup AS, Oslo, Norway

On 3/1/2010 5:11 AM, oddbande wrote:
existing database.
That is VARCHAR2, "DATE" (with time), and NUMBER require a fresh database.
Imagine you had a NOT NULL string column with some empty strings.
Once you turned on VARCHAR2 the data would violate the NOT NULL constraint.
There are similar (but harder to explain) reasons for NUMBER and "DATE".

db2set DB2_COMPATIBILITY_VECTOR=F8F
should be safe.
Remember to restart the instance.
Also you need to run db2updv97 on a DB2 9.7 FP1 instance to pick up the
Oracle data dictionary views and the packages since they obviously were
not deployed when your database was originally created.

Also please note that I'm building a public wiki for the topic:
http://tinyurl.com/Oracle2DB2Wiki

Cheers
Serge
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab