Tag Archives: PeopleSoft Tutorials

Call UNIX from SQR

Calling UNIX scripts from SQR

It often requires us to invoke OS commands from within an SQR. Today we will see how to use the call system command from within the SQR to invoke a UNIX script.

Arrays in SQRs

Arrays in SQR

An Array, like a database record, is organized as rows and columns. But unlike a database record, Arrays exists only in memory and NOT in the disk. This post discusses the arrays in SQR in detail

Comments in SQRs

Comments in SQR

It’s always a good practice to comment your code. By doing this, your code become more understandable and thus maintainable. This holds good for all programming languages and SQR is no exception.

SQR Load-lookup

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

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

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.

Dropdown Values from Peoplecode

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 »

UNIX Commands

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 »

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 »