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.

Note

  • 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

trace-of-sql-statements2

trace-of-sql-statements11

Posted by Vijayakumar Janagiraman
Comments (1)
June 2nd, 2008

Comments (1)

mutyala rao - July 1st, 2009

This doesn't run on OS390 process scheduler?

Comments are closed.