Re: View QMQry Source in RDP

Hi Buck

Just to level-set, I've learned a lot from your EXCSQL stuff - not sure if that's the exact name, of course.

So I'm adding a bit here (standing on your shoulders, so to speak) that might help clarify things a bit.

STRQM is Query Manager - the interface for working with QM objects, as you describe.

We don't HAVE to create *QMFORMs, but they do need ultimately to have a *QMQRY as data source. But there is a system default form that can be used.

I have a feeling - not based on being told, of course - that all QMQRYs are kind of source-based. Maybe there's an internal source, maybe just in memory, that STRQM uses. Doesn't matter to me much though.

RTVQMQRY doesn't retrieve source for QMFORMs - have to use RTVQMFORM for that. This brings up a thought - Query/400 queries combine data and presentation in one object, QM separates them. And the RTVQM* commands can be used to get QM source from QRYDFNs - pretty cool!

I find that STRQM is most beneficial in working with forms - as you suggest, it's painful to directly edit QMFORM source - fixed-format to the nth degree!!

I added a couple type codes to Turnover for QM objects, as I recall, at a previous employer. I also added user actions in RSE for the RTVQM* and CRTQM* stuff, as I recall. I would never directly edit form source, however, I'd go to STRQM for that. But it needed for Turnover to handle.

As for prompting, STRQM uses the same prompter as STRSQL. I've heard, so it's pretty old-fashioned and doesn't support a lot of the new stuff - not sure how well Data Studio does that, just haven't had time for more extensive testing.

And prompting is not available in STRQM, once you put in substitution variables.

Anyhow, just more thoughts on one of my favorite things, next to schnitzel with noodles! (obscure cinematic reference)

Vern

On 5/23/2013 1:27 PM, Buck Calabro wrote:

On 5/23/2013 2:15 PM, Anderson, Kurt wrote:

Buck,

I guess I wasn't aware of CRTQMQRY. I am in fact using STRQM (and to run it in a CL - STRQMQRY).

STRQM creates two objects: a *QMQRY and a *QMFORM. The form holds
formatting instructions and the query holds the SQL. ish. You can
convert STRQM queries to source-based queries via RTVQMQRY. This will
result in two source files: QQMQRYSRC and QQMFORMSRC. The query part is
easy to understand and edit. The form part can be a challenge. Once
you've retrieved and edited the source you need to CRTQMFORM and CRTQMQRY.

If you mostly change the SQL and rarely change the presentation, this
can work out OK. If you need to change the presentation (more columns,
etc) then you'll probably be best served by copying the SQL into the
STRQM session and using that editor to handle the formatting. After
getting it just so, RTVQMQRY again to get the source back out.

Lot of work for a small change until you get comfortable with QMFORMs.
--buck

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Buck Calabro
Sent: Thursday, May 23, 2013 1:13 PM
To: wdsci-l@xxxxxxxxxxxx
Subject: Re: [WDSCI-L] View QMQry Source in RDP

On 5/23/2013 1:28 PM, Kurt wrote:

Is there a way to work with QMQry source in RDP?

I would like to update some SQL and I was thinking it'd be nice if I could do it in RDP. I know I can do it in RDP (or wherever) and copy what I want into QMQry, but I'd like to be able to directly modify the QMQry source from RDP.

To be clear, I think you are not talking about editing QQMQRYSRC; the place the source is stored for the CRTQMQRY command; the resulting object executed via STRQMQRY. RDp works fine for this although there is no prompting available.

I think you are talking about STRQM, which doesn't seem to have a source file associated with it. The 'source' seems embedded in the *QMQRY object. Unless STRQM has a secret stash where it keeps the source, I don't think any external editor is going to work with these.
--buck