On 15-Sep-2016 20:20 -0600, lano dubz wrote:
> On 09-Sep-2016 21:37 -0600, lano dubz wrote:
>>
>> How can I use AS/400 to run a query to change other query dates?
Presumably "run a query" refers to the Query Definition (QRYDFN) object
type, as would be created by the Query/400 [aka IBM i Query] feature;
and "run", either via the Option-9=Run within the Work With Queries
(WRKQRY) interface, or via the Run Query (RUNQRY) command [optionally
with the Record Selection Prompting (RCDSLT) feature requested].
>>
>> Can it be done every day? At work I have to change over 100 query
>> dates.
>> Instead, I want to create one query to run, and [ed: �to have that
>> one query?] change those 100 query dates.
>>
As Buck replied, the Query/400 feature is a Report Writer, not a
programming feature by which /changes/ can be made to other objects;
running a query can replace or add /data/ to a database file, but can
not effect other *change* activity,
From the description of what is desired, I infer what might be best
[per /daily/ need for change], is to change the [�apparently ~100?]
query objects to reference the CURRENT_DATE instead of referencing a
literal-date value?
>
> Dinob. thanks for the advise as it relates to running a query to
> change other query dates.
That reply
[https://groups.google.com/d/msg/comp.sys.ibm.as400.misc/Gm_nbqo9_oE/9EIqDnpjAQAJ]
suggesting the possibility to use a /variable/ name is specific to
reference to the _date_ value in the Select Records option from the
Define The Query panel. As well, the important caveat for restrictions
and limitations on the support of the Start Query Management Query
(STRQMQRY) feature was left unmentioned; the ability to /run a query/
via the alternate QM report writer must not be presumed to be generally
functional, and any query for which such alternative interface might be
utilized should first be reviewed with the Analyze Query (ANZQRY)
feature to verify what functions might not be available and thus how the
results might not be desirable.
> but I need you to break it down a little more to me since I'm also
> fairly new to the whole AS400.
>
> Please respond ASAP; I'm at work now and I could try it on our test
> environment. Do you have an email I could reach you on?
USENET is not really a good place to seek /urgent/ assistance; that is
the domain of your service provider, though in this case, for apparent
usage support vs defect support.
If the topic is really Query/400, then I might be one of the best
resources to assist; I worked on the product for some years, but I have
been busy with other things of late, and typically I will respond most
timely to topics that provide good [background] information\details
about the issue. In this topic, we do not even know for sure what
"query" feature is being utilized.
This may be far too late of a response, but if there is still an issue
to be resolved, do post a followup; but first, see the below:
> I want to share some screen shots I took.
Again, if the topic is the IBM i Query feature: The Option-6=Print from
the Work With Queries (WRKQRY) feature provides text output, and the
5250 host-print also provides text output such that any /screen shots/
need not be taken as images; if images were really deemed valuable over
text [though I can not imagine how images could be better], then there
are numerous places on the web where such data can be posted and shared.
--
Regards, Chuck