IBM-i (AS400) file "union" mapping

[Sans]

Hi to everyone

I have a C10 that should read an IBM-i (AS400) table, the problem is that it's not a "normal" table or a logical file (an AS400 view) but it's an "union" table that puts together 3 normal tables of AS400.
With FM I'm able to see the 3 tables but not the "union" one nor as Tabe or as View when mapping them on AS400.

I use a work-around in FM by defining a Union Query Set that merges the first 2 tables and then another Query Set that merges the last table and the previous Query Set.
It works but the response is not so performing.....any experience in such a matter ??  Ideas ??

Thanks
Luigi

[Lynn]

I am not familiar with that type of object, but doing the union in your framework model will result in local process on the Cognos server to put the data together. This is a bad idea for performance reasons, as you've discovered. You need the database to do the heavy lifting.

What happens if you create a view in the database that does a select * from the union table? Presumably that would be visible to you in FM as a view.

[Sans]

Hi Lynn


thanks a lot for this simple but great idea.....it works !!
performance are now normal

Thanks e Ciao

[Lynn]

Yay! Glad it worked and I'm happy to help a fellow Italian  :)