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



Thanks, but the problem is that the request came from a user who only has
access to WRKQRY and nothing else. He creates his own queries, creating an
ad hoc output file, which he uses in further queries. So it is not that he
needs one file, which I could have created for him.

I have informed him that it cannot be done.


On Mon, Jun 24, 2013 at 2:33 PM, CRPence <CRPbottle@xxxxxxxxx> wrote:

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.

--
Regards, Chuck
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

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.