Re: SQL: How to change *COLHDG to include spaces between words

On 12/11/2015 5:24 PM, Stone, Joel wrote:

I am using QMQRY to an *OUTFILE.

So the easiest method may be to have a second QMQRY to do the "Label On" to define the colhdg values.

Is it possible to do this in one QMQRY source file? No biggie to add a second QMQRY run, but I was hoping that I could get away with something as simple as using the word "AS" to rename the field, hoping I could use "Label On" in the select statement somehow to define the colhdg.

Some ideas to consider:
1) Use a permanent file. You can build it initially with QMQRY, then
use RUNSQLSTM to do the ALTER TABLE LABEL ON... Let your current QMQRY
do a *REPLACE.
2) Keep the QMQRY as-is, add RUNSQL to the process to add the labels
after the QMQRY has run.
3) Assuming you are building a file to be consumed by something
downstream, build a VIEW instead so that the file is always up to date.
Eliminate the QMQRY altogether.
4) Make a model table with the LABELS you want and use CRTDUPOBJ or
SELECT NODATA to copy the 'template' into your temporary file location.
Leave the QMQRY as-is except for *REPLACE.
5) Move the whole thing into an HLL rather than use a utility.
6) Move the whole thing into a script that you execute via RUNSQLSTM.