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

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
______________________________________________________________________