quick "check for data" query before other queries run?
Greetings, long-time lurker, first time asker.
OpenText Analytics Designer
Build id: v20160406
I am working on a report that runs some complex queries against a few tables in a DB2 Z/OS dbase. These queries can take a long time to run, which is fine if the user gets the data they need at the end. However I am finding that they also take a long time to run even if there is no data returned for the user-entered parameters.
Any thoughts? Is this a terrible idea? Do I just need to ask my enterprise architect to get this database off a mainframe and onto linux servers where it belongs?