How to debug SQR in PeopleSoft?

Debugging Techniques in SQR

1. 1) SHOW/DISPLAY Commands can be used any where expect in SETUP section.
2. 2) SHOW/DISPLAY Commands show the text and variable information on the screen and at the same time they redirect their information to log file.

How to debug in SQR?

SQR provides the #DEBUG command to help you make temporary changes to the code. Use the #DEBUG command to conditionally process portions of the program. When the #DEBUG precedes a command, that command is processed only if the -DEBUG flag is specified in the SQR command line.

How do I use trace in SQR?

To enable the trace link in the Sign on page….SQR Tracing

1. Open the process definition.
2. Select the overrides tab.
3. Select Append on the parameters field.
4. Enter –DEBUG[ABC]… (replace ABC with the debug letters. provided in the sqr, sqc source).
5. Save the record.

How do I enable SQL trace in Peoplesoft?

To enable SQL trace in versions 8.0 and higher, the user simply needs to click on the “To set trace flags, click here” link, which leads to a sign in page that includes the SQL trace settings. An alternate way to enable trace if the link is not provided is to add “&trace=y” to the sign in URL.

Where is the DEBUGX flag in SQR-PeopleTools?

Make sure that you have placed -debugx flag in the command line options .As I am running from process scheduler I have made the changes in Process (PeopleTools ->Process Scheduler) In addition to these , Some of the command line flags are very useful while in debugging .

How to debug code in SQR-PeopleTools 8.55?

In above part of coding we are able to track the complete section of code .This looks likes in the following way in the log file. Make sure that you have placed -debugx flag in the command line options .As I am running from process scheduler I have made the changes in Process (PeopleTools ->Process Scheduler)

Is there a way to debug a SQR program?

Debugging of a SQR program can be done in many ways. They are 3) Difference between these two commands is SHOW can capable of showing more than one variable at a time.

What does SQR for PeopleSoft language reference do?

It also provides a directory to the library of sample SQR programs, an overview of the SQR initialization file, and a listing of SQR messages. This reference is intended for SQR and SQL developers who must report on data from a wide range of enterprise Data Sources.