Re: Cache & VMS Batch processing

[Jeff Williams]

I have never automated any of the queries in Report Writer.  There is an 
IDX specific group at Yahoo Groups.  Someone on that group has done it and 
should be able to help.

The issue that you are going to have to deal with is how to handle the 
form.  Navigating the form from DCL can be done-but it takes a bit of 
setup.

First - you need to make sure you have setup the Batch user in DBMS setup.
Once you have done that - set SECID to this batch user when you call into 
the system (use a wrapper routine to call the IDX routine), then you can 
use in your script |F10|, |F7Q|, |DOWN|, etc... to move around the form 
and file.

Jeff
On Tue, 30 Mar 2004 18:07:43 -0600, d <[EMAIL PROTECTED]> wrote:
I know VMS extremely well, but not as much when it comes to the apps. The
following is what they are using.
F3(Report Writer)/A1(Query Edit/Run/Print)
Yes it is IDX, I want to take the query and submit it using a batch file
from VMS instead of manually doing the above. Any help would be 
appreciated.

Thanks

"Jeff Williams" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Looks to me like you are trying to automate something in IDX - if so, 
then
you will find that there is a problem when trying to automate
forms/screens
and selectors.  If not, then what you can do in your command procedure 
is:

$! Run IDX activity
$ csession cache -"U" <namespace> "TAG^ROUTINE"
H
$! back from the application
The space above is an in-line deck and is read by the system as a 
carriage
return.  This will answer your prompt.

If you need more help, let me know what application, function, activity
and
all associated prompts and I'll see if I can put something together.
HTH,
Jeff
"d" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
> Okay -- here is a sample of the Query, it prompts for an input at the
> bottom??  And they need to run it in batch -- Thanks for any help
> SELECT
>
>      ID,
>
>      Name1(,1),
>
>      Name2(,2)$Place(" ",1),
>
>      Social,
>
>      Type,
>
>      DISTINCT City,
>
>      FROM
>
>      Table1,
>
>      Tabl2
>
>      WHERE
>
>      Type = "Male" and
>
>      City IS NOT NULL
>
>
>
>
>
> Press <Return> to continue, or press <F7><Q> to quit:
>
> "Peter Reeves" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> >
> > "Denver Braughler" <[EMAIL PROTECTED]> wrote in message
> > news:[EMAIL PROTECTED]
> > > dsaf wrote:
> > > > Yes, they would like to have it run from a batch file and have 
VMS
> > control
> > > > it in the nightrun jobs.
> > > $cd correct_path
> > > $create query.com !(or whatever):
> > > $ submit query.com /after="tomorrow+1:00" /jobname="niteQuery"
> > > $ cache -B
> > >  ;put query here
> > > halt
> > > $ <ctrl-z>
> >
> > Why are you specifying the -B flag?
> > That overrides the lock out of users during startup or if Cache' is
> started
> > 'nostu'.
> >
> >
>
>




--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/