[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: [sqr-users] Using Process Scheduler in SQR

SYSTEM CALL FUNTION default is wait on the unix servers

Did you try 
CALL SYSTEM USING "command" status NOWAIT --- instead ? should allow to run 
multiple at the same time.



----- Original Message ----
From: Vamsi Krishna Reddy Valluru <vvamsireddy@gmail.com>
To: This list is for discussion about the SQR database reporting language from 
Hyperion Solutions. <sqr-users@sqrug.org>
Sent: Wednesday, February 21, 2007 1:30:02 AM
Subject: Re: [sqr-users] Using Process Scheduler in SQR

 Thank u for the reply...

Yes Arun .. that is exactly what I want...
 *****!Do you mean the Equivalent of this function in SQR?
 *****!  RunProcess("SQR Report", PRCSNAME, "", &RPT_PARMS, "")

To elaborate...

I am writing an sqr which in turn should spawn other sqrs(Independent
sub-Tasks)... but should not wait between the different SQRs(something like
multi threading in Java).

Do u think we can achieve this using SQR.

I am currently using System call to invoke the SQRs. but the main problem
with this approach is it does not return to the actual program until the
child SQR ran completely, hence I am not acheiving any parralel processing.
and so I want know whether I can use the CreateProcess kind of function in
SQR as in Peoplecode.

Thanks & Regards..
vamsi

On 2/20/07, Arun Kumar <arunkumar13@yahoo.com> wrote:
>
> I am not sure what you want to do.
>
> Because any sqr delivered by peoplesoft can be run from command line and
> they will prompt user for all the values it expects.
>
> Can I create a process request using SQR -- the way we use in peoplecode.
>
> Do you mean the Equivalent of this function in SQR?
>    RunProcess("SQR Report", PRCSNAME, "", &RPT_PARMS, "")
>
>
>
> more details please ...
>
> Are you stuck in a particular place in coding that you are looking for
> help?
>
> ----- Original Message ----
> From: Vamsi Krishna Reddy Valluru <vvamsireddy@gmail.com>
> To: sqr-users@sqrug.org
> Sent: Tuesday, February 20, 2007 12:08:53 AM
> Subject: [sqr-users] Using Process Scheduler in SQR
>
> Hi,
>
> Can I create a process request using SQR? I want to use the process
> scheduler in SQR, the way we use in peoplecode.
>
> If have done it before or have the knowledge on how to do it...
> Please help me ... Examples would help a lot...
>
> Thanks & Regards
> Vamsi Krishna
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>
>
>
>
>
>
>
>
>
> 
>____________________________________________________________________________________
> The fish are biting.
> Get more visitors on your site using Yahoo! Search Marketing.
> http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users







 
____________________________________________________________________________________
Never Miss an Email
Stay connected with Yahoo! Mail on your mobile.  Get started!
http://mobile.yahoo.com/services?promote=mail

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users