That's not a column heading, it's an alias name - and with the lack of a real column heading and no column text, the system uses the name as the column heading.

You could make a temp table (declare global temporary table) and do LABEL ON column-name is 'Net Bus/Lbs' - be sure that in the value that you honor the 20-character segments - column headings can be 60 long and are made of 3 20-char segments.

You can get column headings, even long ones, using Query Management forms - but this is a reporting tool - things like the SEQUEL product and Web Query and Query/400 (old name) will give you the option, but nothing I know of in native SQL.

SEQUEL has the ability to specify edit codes and edit words and column headings, at least, in their proprietary SELECT statement - can be pretty cool for what you're doing. Available at Help Systems - maybe see if y'all have it at your place.


On 12/10/2015 4:36 PM, Stone, Joel wrote:
I would like to add a col hdg to an SQL field in a select statement:

q.A0182_PRICED_QTY as "Net Bus/Lbs"

Unfortunately the iseries SQL engine creates the field with a column heading which actually contains the double-quotes.

Is it possible to have spaces in the colhdg as one would expect, but not include any quote characters?

Thanks in advance!

This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].