Re: Call using system without pressing enter

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

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