SQR

How To Read Peoplesoft Run Control Parameters In SQR

Peoplesoft allows the user to give direction to an SQR program by entering parameters on a webpage before the Process Scheduler runs PSSQR. Here is a new way to get those parameters to the SQR program
SQR Command Line Parameters

SQR Code

Some times requirement comes to genrate the output file (csv or any other) at the default output directory so that it can be accesible from the Process Monitor's 'View Log/Trace' page.
To achive this below code will be helpful-

[code]
begin-procedure Init-Report

do Stdapi-Init

if $prcs_process_instance = ''
!No Prompt
do Ask-As-Of-Date
else
display 'Going to select-parameters'
do Select-Parameters
end-if
do Init_Printer
do Init_Report_Translation ($ReportID, $Language_cd)

if $language_cd = 'JPN'
let $qualifier = 'NAME_AC'
else