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

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

I don't think the SQR language has tools for multi-threading, except for the
"nowait" parameter of "call system," which works on some operating systems,
but not others.

You could write an Application Engine program that runs continually in a
loop and checks a "request" table once every 10 seconds.  The SQR program
could place a request in that table, for the AE program to perform.


-----Original Message-----
From: sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org
[mailto:sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org] On
Behalf Of Vamsi Krishna Reddy Valluru
Sent: Tuesday, February 20, 2007 10:30 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
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

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