Hi User1971,
This question is a little confusing. So here's what I think you're asking.
1. You need to create a single view from multiple tables
in order to do that:
2. I need to create multiple objects first to contain the data I need.
So, you can easily create ,multiple persistent objects in Maximo as these will then create the tables. Then I would advise creating the view using the DB SQL query tools, once satisfied, create the view as an object in Maxmo. The best way to do that is to create the object using the same name as the view. Maximo will then import the view and construct the object.
Craig.
------------------------------
===============================
Craig Kokay,
Lead Senior Maximo/IoT Consultant
ISW
Sydney, NSW, Australia
Ph: 0411-682-040
=================================
#IBMChampion2021
------------------------------