Peoplesoft and SQR

I wish SQL had a simple copy command.  It would insert a new row into a table with almost all the values of an existing row of that table.
Continue reading ‘SQL Copy Function In SQR, Part 1’ »

Of course we can use arrays like tables.  What else can we do? Continue reading ‘Hooray For Arrays.Part(2)’ »

I’ve mentioned arrays while writing about other topics.  It’s time I write about arrays.  Someone could program in SQR for a whole career without ever using them, but that someone would have to work harder to do without these handy data objects. Continue reading ‘Hooray For Arrays.Part(1)’ »

It is refreshing to have a new copy of the production database instance in the development database instance. It is also a bit frightening. Was anything important lost in the overwrite? Continue reading ‘Never Fear A Database Refresh Again’ »

The Assignment

Last week we looked at various techniques for combining tables.  As an example, we took an assignment “to gather the hours reported on timecards for each employee over a two week pay period.”  We saw five ways to combine the Peoplesoft HCM tables PS_EMPLOYEES and PS_TL_RPTD_TIME.

By the end, I realized that there was no actual business problem that could be solved correctly and efficiently with this approach. Continue reading ‘Bad SQL Redesigned’ »

Here are some interesting variations of SQL syntax. The simple example I chose is probably ill suited for any actual program, but that makes it more interesting. Continue reading ‘6 Lessons Learned From Bad SQL’ »

We built and enhanced a real-time dashboard that alerted us to problems with Peoplesoft process instances. The next challenge is to investigate processes that fail, or processes that succeeded yet dissatisfied our co-workers (the output was not as expected). Let’s build an SQR toolkit to help us do that. Continue reading ‘Analyze Peoplesoft Process Instances With SQR’ »

Last week we wrote a real-time application in SQR. Yes, in SQR, the batch programming language. That should have been more thrilling than it turned out to be. Let’s try to make it more interesting, accessible, and informative. Continue reading ‘Real-Time SQR Process Monitor Dashboard 2’ »

SQR is a language primarily for batch processing, but it does have limited support for real time, interactive applications.  Let’s build a process monitor that is better than (or at least different from) Peoplesoft’s version. Continue reading ‘Real-Time SQR Process Monitor Dashboard 1’ »

Here are some small but significant ways to speed up or streamline your SQR program. Continue reading ‘7 Little SQL Tricks’ »