If you can have the EXE in each location do it. You can create the parametrized views to retrieve the info. Make sure that your tables have the correct index and the view is full optimized. Check the SYS(3054) function to see the optimizartion level of your view.
"Anyone who has never made a mistake has never tried anything new." A.E
"The important thing is not to stop questioning. Curiosity has its own reason for existing." A.E