Export & Import LANSA Defined Tables with SQL Views

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: 27
Joined: Sat Jan 16, 2016 9:53 am

Export & Import LANSA Defined Tables with SQL Views

Post by appbuilder » Tue Jul 23, 2024 3:09 am

Has anyone had success exporting and importing tables with SQL Views in a library different than the Default file library? We have encountered errors and had to remove the SQL View from the table before exporting. Then manually recreating the SQL View(s) in both the exporting system and the importing system.

The error on export is trying to find the table in the library where the view exists and not the LANSA default file library as follows:
W EIM0005 Object CRSPCC of type *SRVPGM from library WEBLIB cannot be exported. See following messages.
W CPF9801 Object CRSPCC in library WEBLIB not found.
W CPF2105 Object CRSPCC in WEBLIB type *SRVPGM not found.
W CPF2130 0 objects duplicated. 1 objects not duplicated.

It seems to be picking up the library from the location of the view on the table CRSPCC and the using the LANSA Default File library.

Any suggesting?
Thanks,

Don

Post Reply