Re: > Re: > executing PS query from Windows command line
Sibi Joseph V
Which version you are using?
I am not seeing that table in the database itself. My
tools version is 8.19
--- PeopleSo...@googlegroups.com
<gupta...@gmail.com> wrote:
> Sibi
>
> You can run ps queries from command line. I have
done that. There is a
> delivered app engine called PSQUERY that is
triggered in such cases. You ca
> n
> see that app engine when you schedule a query from
the Schedule Query page.
> when u try to schedule a query and specify a run
time, u are basically
> triggering an appengine which pulls run control
information from
> PS_QUERY_RUN_PARM table.
>
> since it is an app engine, it can be triggered from
command line. i could d
> o
> that and fyi, it is working. I just moved it to
production today.
>
>
> again, the specific query I mentioned earlier (the
one with 13 unions) is
> still not working. and i am looking for answers.
the query runs fine when
> you go to query manager and do a preview. But when
you try to schedule the
> query, it bombs with no valid or unique reason.
>
> thanks
> anand
>
> On 1/16/06, Sibi Joseph V <sibi_...@yahoo.com>
wrote:
> >
> >
> > Hi,
> >
> > As per my understanding psquery cannot be run from
the
> > command line. Its like you are trying to run the
> > application designer from the command line.
> > If anybody have different opinion please share it.
> >
> > Thanks.
> > --- PeopleSo...@googlegroups.com
> > <gupta...@gmail.com> wrote:
> > >
> > > Hi
> > >
> > > I have a requirement to run PS queries from
windows
> > command line (not
> > > use the NT process scheduler) on a 3rd party
> > scheduler tool. I am on
> > > tools 8.45.
> > >
> > > When I execute the following command, I am able
to
> > run the PS query
> > >
> > > psae.exe -CT DB2UNIX -CD GLQUALDB -CO <UID> -CP
> > <PWD> -R APHBC_APR13 -I
> > > 0 -AI PSQUERY -OT 2 -FP \\gl0200t\rpts\ -OF 2
> > >
> > > When I execute a PS query from query manager, it
is
> > running fine. (it
> > > is a massive query with 13 unions). But when I
try
> > to run the query
> > > from command line, using the above, it errors
out.
> > The error says
> > > PSQUERY app engine abends, but does not give any
> > valid reason as such.
> > >
> > >
> > > Also, seems there is a problem in printing PDFs.
> > Does someone know what
> > > could cause an issue in writing PDF outputs from
> > queries on command
> > > line?
> > >
> > > Thanks in advance
> > > Anand
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam
protection around
> > http://mail.yahoo.com
> >
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Anand Gupta
I havent worked on 8.19 or below since a long time now, so do not remember. But there should be some way to schedule PS queries on the process scheduler. When you schedule the queries, what program do you schedule to run? or maybe I am missing completely and you cannot schedule ps queries at all..