Just a short note today showing you how to activate the debugging parameters on an SQR.
On the process definition, select to the Override options page and enter the following:
The –debugxyz will invoke any lines of code that start #debugx or #debugy or #debugz (these are the debug characters used in the delivered SQRs – so you could include your own lines of code starting #debuga). The output from these lines of code will be sent to the log file.
The –s will invoke the SQL cursor status. The output from that will be sent to the *.out file like below:
That’s it for today – hope it helps.