Technical Blog Post
Abstract
How to Migrate existing Oracle View into Maximo Database Configuration
Body
Depending on what you want to achieve, here's a basic guide on how to
migrate Oracle view into Maximo DB.
1) Create a view directly on the backend.
Create view MPCASSET as select * from asset;
later, you can select all records from MPCASSET, just to see the
resultSet, the same as in ASSET
2) Go to Maximo DB Config, and click New
Type the same name... MPCASSET
The app will automatically recognize the existing view and set Is View= trueSelect ASSET as the Extends Object
You may have to use the options for Join Object and View Where if you want more complex views .
Save
3) Run DB Config.
And here are some technotes that can also help as guide:
Having trouble creating a view by joining 2 objects?
Unable to View Data From a New Field in Computers Application
UID
ibm11130757