×
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 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.