List/Grid

Reporting Subscribe to Reporting

remove special characters function in SQR

SQR: Function to Remove Special Characters

Last week we were discussing about a piece of code that would remove special characters from a string. This was used in an SQR that writes to a .csv file…. Read more »

remove special characters in SQR

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 »

Record used in the example graphic

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 »

SQL Update Fields from Another Table

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 »