Re: Blocking QM Queries Was: WRKQRY - getting the SELECT records date range to show in the title

On 21-Jul-2010 12:47, Luis Rodriguez wrote:

I agree. There is always the case of companies like the bank
where my wife works. Although she is a project manager, they only
have access to Query/400 and QM is out of bonds. I really believe
is due to the ignorance of their Sys Admin and DB2 personnel (I
often hit a wall every time she asks me for help: no SQL, no QM,
etc. It is a wonder they don't run S/36 on their 595!)

Just go around the wall ;-) Direct her to one of the many other
ways to get to the SQL, instead of limiting options to just the
STRQM and STRSQL. For example, the RUNQRY QRYFILE(QTEMP/TheVIEW)
should be easy enough, given a SELECT-stmt-as-input for the dynamic
SQL statement 'CREATE VIEW QTEMP/TheVIEW AS ( ' concat
SELECT-stmt-as-input concat ' )'

Regards, Chuck
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.