Trace of SQL statements which runs in SQR program
If you find very hard to debug the SQR program, the order in which the SQL runs (from multiple SQC’s), the number of rows processed…In such case, PeopleSoft provides a run time variable to be substituted in the command line argument of the SQR program to display the order in which the SQL statement executed in SQR program, Exact text of SQL statement with values substituted in variables, the number of rows returned… The following steps needs to be followed to attain this:
- In the Processes navigation (‘Home > PeopleTools > Process Scheduler > Processes’) for the specified process, under ‘Override Options’ tab set the Parameter list value as ‘-S’ with ‘Append’ mode.
- Run the SQR process and view the output in log file.
- The log file of the process occupies more space due to the information in it. Hence, use the parameter only for testing purpose and remove it before migrating to testing or production environment