Re: Call using system without pressing enter

["Blakeslee, Andy" <ALBlakeslee@HOMELOAN.COM>]

add the -xcb flag to the command line used to launch the sqr.

> -----Original Message-----
> From: Everry Man [SMTP:everryman@HOTMAIL.COM]
> Sent: Monday, February 01, 1999 4:57 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: Call using system without pressing enter
>
> Thanks for the suggestion. I used an @file in the command line call
> statement with the following entries:
> $prcs_process_instance = ''
> #prcs_process_instance = 0
> $prcs_oprid = ''
>
> I no longer have to press ENTER for the program to initiate, but I still
> get the 'Press ENTER to close...' when the SQR is done. Is there a way
> to eliminate this prompt also? I can't seem to find a variable to put in
> the argument file.
>
> Thanks for your help,
> Dan O'Donnell
>
> ---------------------------------------------------------------------
>
>
> If the message you are getting when you have to hit enter is:
>
> 'Please press ENTER (Do not input a value)'
>
> this is coming from the prcsapi.sqc, and is used to determine if the sqr
> is
> being run from the process scheduler or not.  PeopleSoft passes the
> process
> instance number to the sqr at this point.  If you pass an argument file
> (@filename on command line) that has a null value for the argument (just
> a
> CR, no data), that will respond to the prompt for you.
>
> If you are not getting the above message, search your program code for
> other
> input or ask statements - they are the likely culprits.
>
> Thanks,
> Andy
>
> >> -----Original Message-----
> >> From: Everry Man [SMTP:everryman@HOTMAIL.COM]
> >> Sent: Monday, February 01, 1999 11:01 AM
> >> To:   Multiple recipients of list SQR-USERS
> >> Subject:      Call using system without pressing enter
> >>
> >> Hello all,
> >>
> >> I am currently working on an interface between PS HRMS and PS
> >> Financials. I'm trying to update the personal_data table and vendor
> >> tables each night by running an SQR from the Process Scheduler. My
> >> problem is that although running the main SQR from Process Scheduler
> >> will not require that anyone presses enter to register the
> environment
> >> variables, my source SQR calls another SQR program to execute against
> >> separate database which will not run until I hit enter. Here is the
> >> environment that I'm running in:
> >> SQR 3.0.16.4
> >> NT Workstation 4.0
> >> NT Server 4.0
> >> SQL Server 6.5
> >> PS Financials and HRMS 7.0
> >>
> >> Could anyone help me with how I can do the call system without anyone
> >> having to stand there and press enter when the box comes up?
> >>
> >> Thanks in advance.....I've pasted the main procedure below,
> >> Dan O'Donnell
> >>
> >> !************
> >> Begin-Program
> >> !************
> >>
> >>   do Init-Report
> >>   call system using 'r:\hr700\bin\client\winx86\psdmt.exe -CT
> MICROSFT
> >> -CS servername -CD databasename -CO user -CP password -CI user -CW
> >> password -FP c:\temp\ccc_pers_data_export.dms' #status1
> >>   show 'DataMover Export Status: ' #status1
> >>   do Process-Main
> >>   call system using 'c:\winnt\system32\cmd.exe /c start /wait
> >> r:\hr700\sqrbinw\sqrw.exe c:\temp\Interface.sqr
> >> databasename/user/password -ir:\hr700\sqr\' #status2
> >>   show 'Interface status: ' #status2
> >>   do StdAPI-Term
> >>
> >> End-Program
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com