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?
Export & Import LANSA Defined Tables with SQL Views
-
- Posts: 27
- Joined: Sat Jan 16, 2016 9:53 am