I am migrating from Oracle 10g to DB2 v9.7 using IBMDMT v(2.00-b2114). I notice that column names are replaced by schema name in all the views due to which views can not be migrated/deployed . This is happening in previous versins of IBMDMT as well . Can you please see attached snap and look into the issue .
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
3 replies Latest Post - 2011-10-25T11:32:07Z by SystemAdmin
Pinned topic Column names are replaced by schema name in views during migration
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-10-25T11:32:07Z at 2011-10-25T11:32:07Z by SystemAdmin
SystemAdmin 110000D4XK708 Posts
ShariqHanif 270004QAD82 PostsACCEPTED ANSWER
Re: Column names are replaced by schema name in views during migration2011-10-23T11:44:53Z in response to SystemAdminThanks for your reply Raul .
For some reason there is no IBMExtract.properties for v2114 so I am attaching v2.00-b1758 file .
SystemAdmin 110000D4XK708 PostsACCEPTED ANSWER
Re: Column names are replaced by schema name in views during migration2011-10-25T11:32:07Z in response to ShariqHanifHi Shariq, I have compared your file to mine but have found minor differences.
and mine also has (and yours doesn't have)
but I don't think this might be the difference. We haven't experienced this issue.
Our last build version was 2.00-b1799.