Re: RUNSQSTM

On 30 May 2013 04:31, rob@xxxxxxxxx wrote:

If you want to store your SELECT statement and rerun it upon a
periodic basis there are a few things you can do. One option
<<SNIP>>

Another option is to create a temporary table. Wrap your existing
statement with this
create table mylib.mytable as(
... your existing statement here ...
)
Then you can query that temporary table.

That "temporary table" would not have any data, for lack of the WITH DATA clause. Also, a more appropriate CREATE might be a CREATE VIEW to encapsulate the SELECT statement; i.e. why generate a full copy of the selected data, possibly stale data, when the active data can be queried directly? Within the script environment, then a RUNQRY *N ViewName can be issued to generate a report directly within the script using an SQL CALL to issue that RunQry request in a CL command interpreter.