When attempting to generate DDL for some of the views on our v7.1 system, from within RDi, I only get the view definition part of the DDL not the SQL SELECT part.
We are running RDi v9.0.1. From the Data Source Explorer view, I drill down to the schema/views folder. If I select a view that has null in the QSYS2.SYSVIEWS.VIEW_DEFINITION column (I believe because the view is made up of more than 10000 characters) I have the problem stated above. If the VIEW_DEFINITION column is not null, everything looks fine. My problem is:
I know there is some other way to get the definition because I can still do it in Navigator with no problem (very frustrating).
I can't find anywhere in RDi documentation or anywhere else that tells me a way to configure a fix for what I am doing wrong (even more frustrating).
If you could help me or point me in a better direction, I would be very grateful.