Zutshi Group LLC

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Command Line SQR in Unix ======

Running sqr programs through the command line in UNIX is not difficult.  

Steps for running SQR's in UNIX:
  * Set your Environment
  * Create the run_sqr shell script
  * Run the SQR

===== Setting your environment =====
After connecting to the unix environment, set up your PeopleSoft Environment.  Notice that the command below contains a dot "." followed by a space.  The examples below use the DPSHRDPS environment.
<code>
prompt$ . /opt/psoft/hcm88/dpshrdps/psconfig.sh
</code>

===== Creating the  "run_sqr" shell script =====
Create the run_sqr shell script.  Make sure that you giv "execute access through the shell with **chmod 755 run_sqr**
Replace the values for PS_HOME, PROG and DB.  Remember to replace the XXXXXX with the database's sysadm password.
A sample run_sqr shell script is given below:
<code>
PS_HOME=/opt/psoft/hcm88/dpshrdps
PROG=/opt/psoft/test.sqr
DB=sysadm/XXXXXX@DPSHRDPS
SQR=$PS_HOME/bin/sqr/ORA/bin/sqr
$SQR $PROG $DB -I$PS_HOME/sqr/,$PS_HOME/sqr/user/ -O/tmp/sqr.log -F/tmp/ -ZIF$PS_HOME/sqr/pssqr.ini
</code>

===== Running the SQR =====
This should be as simple as:
<code>
prompt$ ./run_sqr
</code>

The SQR Log **sqr.log** file will end up in /tmp along with the report output.  feel free to change run_sqr's **-O** and **-F** parameters if you want the files to end up in different locations.