Page 1 of 1

SQL View Removed after File Import

Posted: Thu May 08, 2025 1:21 am
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

Re: SQL View Removed after File Import

Posted: Thu May 08, 2025 8:29 am
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.