Tag Archives: PeopleSoft Tutorials

Load-Lookup in SQR
It’s common to join tables within SQRs to retrieve data from normalized tables. As SQL statements consume significant computing resources, such joins may be a hindrance to performance of the SQR. Further, as the number of tables that are used in the join increases, the performance decreases.

Multiple Reports in SQR
Generating multiple reports in SQR is common these days. Writing SQRs that produce multiple reports have many advantages over the other approach of having multiple SQRs do this job. This post discusses how to generate multiple reports in SQR.

Dynamic call-section in Application Engine
Often, business logic requires us to call different sections based on occurrence of certain conditions in different scenarios and that too from the same call-section. To enable this kind of logic, we will have to make the call-section dynamic. This is how we can do it.

Adding Dropdown Values from PeopleCode
Today we will see adding values to a drop down list through Peoplecode. This method becomes essential if you want to dynamically populate the drop down list based on some… Read more

SendMail – Sending HTML Email
If you are looking for a means to send emails with colours, tables and graphics, you have come to the right place. This post explains how to send html emails… Read more

Common UNIX Commands That You Need
While there are a multitude of UNIX commands out there, as PeopleSoft consultants, we do not need to use all of these on a regular basis. As you may know,… Read more

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

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 mid week taking away all our coffee breaks! Once the jobs… 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