Archive for November 2009

SQR Versus Application Engine

What is the relationship between SQR and Application Engine?  Is one better or are they complementary?  They are both frameworks for batch processing in the Peoplesoft environment.  As such, they must have overlapping functionality.  Like Star Trek and Star Wars, they each have fans and detractors, with not always rational reasons for their preferences.
Continue reading ‘SQR Versus Application Engine’ »

Re-Use Peopletools Run Control Objects

Peoplesoft HCM (HR, BA, PR, and TL) comes with at least 1300 run control records, yet my organization has added 2% more over the past ten years.  We’re not running out of table space or disk space, but we probably did more work than we needed; creating new records, tables, and pages.  For that matter, Oracle probably did more work than they needed, not reusing their run control objects.
Continue reading ‘Re-Use Peopletools Run Control Objects’ »

Vacation, Part II

By now, I’m back from vacation, but I didn’t write anything while I was gone.  I’ll have a new article next week.

I’ve been thinking about my blog.  While spending almost a year writing about SQR, I’ve collected a list of topics relating to SQL, Peopletools, and Peoplesoft HCM that I want to discuss.  I assume most of my readers work in those areas too.  I may begin a new blog on those subjects in the new year, and I hope you’ll join me.  I would update this blog occasionally, but I’ve already said most of what I want to say about SQR.

Vacation, Part I

For the past few weeks, I’ve been working on an exciting Peopletools / Peoplecode project.  It’s hard to focus on SQR.  I’ve also been distracted by my upcoming vacation.  The result?  I haven’t had time to create a new SQR entry for this week.  I’ve got several essays in progress:

  • a program to help choose run control records and pages for a new SQR program
  • a comparison of SQR and Application Engine
  • an business and technical history of the SQR product line

So, please reread my older entries while I’m away.  You haven’t memorized them yet, have you?

Batch User Interfaces

Even batch programs have user interfaces.  They start with actual or implied inputs (run control parameters in Peoplesoft).  They end with actual or implied outputs (reports, log files, Process Monitor messages).  We shouldn’t take these elements of program design for granted, even in the simplest programs.
Continue reading ‘Batch User Interfaces’ »