Re: SQL: How to change *COLHDG to include spaces between words

Joel

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.

HTH
Vern

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 http://www.symanteccloud.com
______________________________________________________________________