I use the QSHQRYTMP and QSHQRYSRC commands as part of my QShell on i tools a lot in my daily travels for running SQL statements and creating output files from the results. Recently I've had more of a need to run multiple commands and aggregate the results to an output file. And I didn't want to start getting overly fancy by writing UNION queries all the time, although they do have their place.
The easiest way to do this was implementing a parameter set that allows the QSHRYTMP and QSHQRYSRC commands to copy their temporary results to a second output file by optionally using the CPYF command. Of course you can do this yourself, but having a CPYF option built right in to QSHQRYTMP and QSHQRYSRC just adds more value when you have a need for multiple SQL queries to aggregate to a single table.
Upgrade to V1.0.55 and give them a spin and let me know what you think.
https://github.com/richardschoen/QshOni
No comments:
Post a Comment