× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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
______________________________________________________________________


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2024 by midrange.com 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.