Re: QMQRY: Does this query tool support long field names (DDS Alias names) on iseries?

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

I'll say yes - QMQRY is just a wrapper around any SQL statement - if you 
can do it in STRSQL you can do it in QM queries. It works with long 
names as defined with DDL - and with that you also get the short names.

If you use STRQM to work with a QM query, you will often see a prompt to 
show the full name of something - just as in STRSQL.

You should probably work in the SQL mode in STRQM, not the PROMPT mode - 
so if the screen says PROMPT near the top somewhere, press F19 (I think) 
to switch.

PROMPT mode is very much like Query/i - comfortable for moving from 
Query to QM if desired.

I know - more than you wanted to know!

A thought to consider - it might be tempting to make too much 
distinction between DDS and DDL - the results as to naming are the same, 
basically.

Yes, I know there are differences and don't need a litany of them, thank 
you very much!!

HTH
Vern

On 11/13/2015 2:11 PM, Stone, Joel wrote:
> If yes, how?
>
> If no, how do you make sense of longer queries with cryptic 6 or 10 character names?
>
> Thanks in advance!
>
>
>
> ______________________________________________________________________
> This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
> For more information please visit http://www.symanteccloud.com
> ______________________________________________________________________