List/Grid
Reporting Subscribe to Reporting
SQR: Function to Remove Special Characters
Last week we were discussing a piece of code that would remove special characters from a string. This was used in an SQR that writes to a .csv file. This… Read more
SQR: Removing Special characters from a String
This week was hectic! Though we had a very normal start, a couple of critical job failures knocked us midweek taking away all our coffee breaks! Once the jobs were… Read more
SQR: Reading from Flat File and Updating a Record
This post is in response to Fred’s request on ToD. He had asked for an SQR program that would read from a flat file and update the values to a… Read more
Updating multiple fields with values from another table
While carrying out day-to-day support for PeopleSoft systems, we often encounter cases where fields in a record must be updated with values from another table. In this post, we will… Read more
