Re: Simplest Way to run SQL in a CL?

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

Evan Harris wrote:
> Hi Scott
>
> If I use an RPG I now have to code and compile an additional program and
> recompile every time I want to change my SQL. If I use a QM Query I simply
> have to edit the QM Source member with the SQL statement.

Wouldn't you also have to recompile your QMQRY source the same way you 
recompile your RPG program?!?!  By your logic, RUNSQLSTM would be 
simpler, since it doesn't have to be compiled like QMQRY does...

Unless I'm confused, you have to run CRTQMQRY to compile a QM Query.


> The QM Query approach is primitive but effective if you just want to run a
> query - and it nicely externalises the SQL from the CL.

You're right...  I just re-read the original message.  I didn't notice 
the first time around that he wanted the results to go to a physical 
file!   I thought he wanted to read the results into variables in his CL 
program.

In that case, RUNSQLSTM or QMQRY would definitely be easier than using 
data queues.

however, I should point out that if you don't need to get the results in 
your CL program, you don't need to use a data queue, either...   the 
point behind the data queue was PURELY that you could get the input into 
your CL program via a data queue.

If the output is meant for a file, it's a simple SQL statement, and 
RUNSQLSTM, QM Query or STRQSH calling the db2 command would all be 
simple, but effective ways of doing this from CL.