×
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.
On 24 Jun 2013 13:17, Vinay Gavankar wrote:
Is there a way to define Text for a Result field created in AS400
Query. It defaults to the "Expression" when the field is added to a
file created as an output of the Query, which is not very helpful.
Query/400 is not expected to be used to create files, outside of
ad-hoc purposes. Thus what the text that is chosen by the utility for
any columns that are generated from an expression, would be generally
immaterial.
Use CREATE TABLE and then LABEL ON for SQL DDL to pre-create the
database file into which output is directed, or use the CRTPF with DDS
to create that output file, if the file must have some specific /text/
or /column heading/ labels. Even if one were to insist-on using the
impromptu\ad-hoc OutFile in a manner for which /better/ labels are
desirable, then, again, the SQL LABEL ON is available to effect some
desirable descriptive text... and the COMMENT ON statement for the /long
comment/ feature available via the F23="Long comment" capability
provided within WRKQRY.
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.
midrange.com
