SQL View Removed after File Import

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
appbuilder
Posts: 28
Joined: Sat Jan 16, 2016 9:53 am

SQL View Removed after File Import

Post by appbuilder »

Does anyone else utilize SQL Views and experience the Views are removed when the file is imported or checked in. We had not been saving the source code as it can be regenerated as needed, but it seems that saving the source code doesn't help.

Any suggestions, advice and guidance would be appreciated.

Thanks,

Don
Thanks,

Don
User avatar
Dino
Posts: 472
Joined: Fri Jul 19, 2019 7:49 am
Location: Robbinsville, NC
Contact:

Re: SQL View Removed after File Import

Post by Dino »

External indexes, external join files. External sql views can be deleted if you import a file PF.
If you only import the OAM or the logical files that won't be an issue.
Lansa cannot delete the physical file, then recreate logical/ indexes created outside of lansa repository as it does not know about those.
Post Reply