H
HPDBA
Guest
Neither the current OpenAccess API nor oa_isql can tell you what the definition of a view is. You can create and drop views, but once created, you can't find out what the DDL is to be able to re-create the view again. This is a real problem for customers that are upgrading, since views may not be compatible between OA versions (depending on what options were used), and therefore after the upgrade the views no longer work, and they can't be easily re-created because you can't figure out how they were created in the first place - unless you happened to have recorded that outside of the software. It would be nice if at least one of the following were true (in order of my preference) 1. Make sure views can ALWAYS be updated between OA versions. 2. Have a 'describe view' statement in oa_isql so that the original view DDL can be duplicated. 3. Have an API call that returns the DDL of a view. 4. if IP has DAM managing views, have DAM call the IP for any view create/alter/drop with the user SQL so that the IP can keep track of the view definition outside of OpenAccess.
Continue reading...
Continue reading...