Running SQR from Command Line – PeopleSoft Tutorial
1

Running SQR from Command Line

You will need to run SQR from a command line usually during upgrades, which makes it real easy to forget how to use it because it is still an old crude method and a single mistake needs you to type the details all over again.

I was looking at what readers are looking for and many of you were looking for this information on how to run sqr from command line, but we did not have that post here. So, here’s to meet your need.

To run a SQR on the client workstation using command line, do the following:

  1. Go to Start -> Run and provide the path of the sqrw.exe and the parameters shows below.
  2. Navigate to the folder <PS_HOME>\bin\sqr\ORA\binw
  3. Select sqrw.exe and double click to open
  4. Add the needed flags using the reference provided below
  5. Click OK and the SQR for the PeopleTools version dialog box will appear, displaying the attributes that you entered in the dialog box.

For example, in my case when I ran the SQR from the command line, below was the input I provided to run dddaudit.sqr:

C:\PT8.53\bin\sqr\ora\BINW\sqrw.exe -ZIFC:\PT8.53\SQR\PSSQR.INI          -iC:\PT8.53\SQR\                     -fC:\temp\dddaudit.htm -keep         -printer:ht

running sqr from command line

For your convenience, the description of flags is mentioned below:

Flag              Description

-I                   Specifies the directories that the SQR will search for the #INCLUDE files.

-f                   Specifies the directory where the report output will be sent. If you use the -keep flag, specify a directory with an ending slash. If you use the -printer flag, specify a full pathname with a filename for the HTML file.

-ZIF              Sets the full path and name of the SQR initialization file. The -ZIF flag should point to your <PS_HOME>\sqr\pssqr.ini file

-keep            Keep the .SPF file after the program runs. This enables you to view the report with the SQR viewer.

-printer:ht   Generates the output in HTML format. Specify the filename with path location, with the -f flag.

 

Creating a Shortcut to Run SQRs

Since the SQR dialog box crashes after each invalid input and to avoid typos, it makes sense to create a shortcut to run SQRs.

  1. Navigate to the folder <PS_HOME>\bin\sqr\ORA\binw
  2. Select sqrw.exe, right click and select create shortcut.
  3. Right click the shortcut you just created and select properties.
  4. On the shortcut tab, add the same sqr flags that you used in the previous task
  5. Click OK
  6. To run the report, provide the values as shows earlier.

creating shortcut for running sqr

Apurva Tripathi
 

Apurva is a PeopleSoft consultant and a big advocate of everything PeopleSoft. He is also a technology enthusiast and loves learning and implementing newer and open source technologies. He spends his spare time updating this blog and likes to read books on self help and productivity.

  • Guillermo says:

    Hi Apurva, I hope you can see this comment right now.

    Here is my problem with SQRW.exe; I’m trying to migrate some SQR’s reports to SSRS which almost all code is done, but when I’m trying to execute the following command line “C:\..\Esqrw>Sqrwt.exe myfile.sqt user/password -Vsqldevserverdb @Parameters.dat” I’ve got an error saying “SQL server is unavailable or not exist”, then another message promt saying “Perhaps: user / password are incorrect. I have QA and DEV servers when I ran the command for QA db works fine and the report got created but when I tried to run this command for DEV sql server the error message appears, the user and password are correct, also I’ve created an ODBC on the server to connect to DEV DB SQL Server and the connection works fine, I’ve tried to search for any suggestion on the internet that might be match with this error and I couldn’t found any yet, so with this description, do you mind if you can share any suggestion on what can I do to resolve this issue?, I hope you do, any help will be much appreciate it.

    Regards,
    @Guillermo

  • >

    Download Complete List of PeopleTools Tables List. Never Again Google It !