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