I developed a catalog which points to an Informix datasource. The tables in the database were owned by various groups and so had different prefixes for the tables (alpha.customers, beta.products, gamma.order_hist) and this is the way they showed up in the catalog (although you could qualify the tables with less detail which would remove that prefix). We have moved the system to SQL Server where dbo is the owner of all the objects, however when looking at the objects in the catalog, it still retains the reference to the original table owner ... this really causes a problem/confusion when working on joining (new) tables...is there a way (utility or other method) to rename the object owner reference in the catalog? I don't want to rebuild the catalog from scratch using the new SQL db as the source just to eliminate the invalid name references.
think I got it....updating the impromptu.ini file with "Schema Leveling Mode=1" gives you access to a hidden feature which allows you to modify the object owner info.