Re: Result field Text in AS400 Query

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.