RE: [sqr-users] How will the sqr get the values ?

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

The Process Type Definition "SQR Report" specifies that the SQR command line
parameters include the OPRID and the RUN_CNTL_ID from the run control page.
Procedure GET-RUN-CONTROL-PARMS in PRCSAPI.SQC (called from procedure
STDAPI-INIT) performs INPUT commands for $database_name,
$prcs_process_instance, $prcs_oprid, and $prcs_run_cntl_id.  INPUT will take
values from the command line if they are present.

-----Original Message-----
From: Syed Husain [mailto:syed.husain@patni.com]
Sent: Thursday, August 11, 2005 3:22 AM
To: 'This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.'
Subject: RE: [sqr-users] How will the sqr get the values ?


Below is the procedure which gets the run control parameters.

do Get-Run-Control-Parms

the two variables that gives the oprid and runcntlid are:

$prcs_oprid
$prcs_run_cntl_id

-----Original Message-----
From: sqr-users-bounces+syed.husain=patni.com@sqrug.org
[mailto:sqr-users-bounces+syed.husain=patni.com@sqrug.org]On Behalf Of
Knapp, Richard
Sent: Thursday, August 11, 2005 3:46 PM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] How will the sqr get the values ?



They are in the job stream.  Include input statements at the beginning of
your program to capture them.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu
-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
RAJENDRA BABU ARI
Sent: Thursday, August 11, 2005 5:12 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] How will the sqr get the values ?

  
Hi all,

How will the sqr get the values runcntlid and oprid from peoplesoft when sqr
report is run from PeoplSoft.



Thanks

_______________________________________________
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