Using IDA 8.1.0, when I reverse engineer a DDL file that has a view with a common table expression, IDA will create the view in the physical data model and remove the common table expression from the SQL. The SQL then becomes invalid.
This does not happen if I reverse engineer a view from a DB2 database. The common table expression is preserved in the view SQL when it is created in the data model.
I have attached a file with a simple view SQL containing a common table expression.
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.
1 reply Latest Post - 2012-11-06T17:52:47Z by null
Pinned topic Reverse engineering views from DDL file
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-11-06T17:52:47Z at 2012-11-06T17:52:47Z by null