Sqr Process In Peoplesoft

Bangalore, Karnataka, India Now PeopleSoft Consultant / Lead Test Analyst at Aon Hewitt, my professional career includes around 7 + years in Astute Business Solutions, Capgemini Consulting India PVT. Ltd & Dell International Services India PVT.n Ltd mainly related to PeopleSoft HRMS/HCM.

During these years, I have worked on Implementation,Upgrade and Support Projects. I'am also in to training PeopleSoft. I have earned a Software Engineer degree from Vijayanagar Engineering College under Visveswaraiah Technological University, Belgaum.Please feel free to contact me on +546 / +613 or chowdary1105@gmail.com.

Sqr Hello World

To trace the status of cursors being executed, append the -S flag to your parameter list. You can do this through the command line (if you're brave) or through the process definition in the override options:While you can normally extract the appropriate SQL from the SQR, there are cases where this proves quite useful. In particular it is really helpful for investigating performance issues with SQRs as it tells you the SQL text, number of compiles, executes and rows related to the cursor.Unfortunately this doesn't resolve dynamic SQL or tell you the value of bind parameters that were passed to the SQL so it certainly has limitations but as far as I know its the closest you can get to a SQL trace in SQR.