|
You could try specifying *OUTFILE for the output type on the STRQMQRY. And
then issue RUNQRY against the *OUTFILE created by the STRQMQRY request.
(Thanks to Chuck Pence for his help on this answer.)
If you want to look at other SQL-based tools, here are some other
alternatives to consider. One alternative would be embedding SQL Prepare &
Execute statements that could construct interactive SQL statements
dynamically and execute them. If you can use a browser interface, you
might want to look at the Net.Data product, it's very easy to embed SELECT statements (without a 255
column limit) and then have Net.Data perform the HTML formatting to display
the results. Another possible alternative would be the graphical version
of DB2 Query Manager - IBM QMF for Windows product. There are even macros
to convert DB2 Query Manager definitions into QMF definitions. For more
info on QMF, including trial download, click here.
==================================
MORE INFORMATION ON THIS TOPIC
==================================
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: tips, tutorials and more.
Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.
|
