Maximo Templates and SQL

iewnhoff

If using a blank template and building a dataset, the sql statement can be built by clicking on the tables and field names. This also populates the output columns. However, when using the IBM supplied Maximo templates this method of building the SQL statement is not longer available. You have to go to the script tab for the dataset, use the open method and type in the sql statement which requires you to enter in each field and table. After doing that, you need to go to the fetch method and enter each field again. Is there a way to use the IBM provided template yet be able to create a dataset using the basic method versus having to go into the script tab and type in commands in the open and fetch methods?

Dragunov

No, There is no way for you to drag and drop tables and see the preview when developing BIRT reports for maximo using maximo templates and libraries. If you want to verify your SQL you can use an SQL editor like TOAD(you need to buy it) or free ware tools like DBvisualizer.