When Peoplebooks Is Not Enough
In the ten years that I have been programming in SQR, I’ve found a few cases where the compiler is a bit more limited than the documentation implied. However, I can only think of one example in which SQRW acted in a way that was unambiguously wrong.
Continue reading ‘A Strange SQR Bug’ »
Peoplesoft HCM has tens of thousands of record definitions, representing tables, views, and other Peopletools objects. Nonetheless, we can find more ways to organize our data usefully for easy access in Query Manager or in database browsers like SQLPlus and TOAD. This is the first of an occasional series of posts regarding new ways to access our data. This week: PS_LEAVE_ACCRUAL.
Continue reading ‘Views You Can Use: Leave Accrual’ »
We may be designers and programmers, but we often need to look at the contents of the database to help our customers deal with problems. I probably spend as much time writing SQL select statements in Quest Software’s TOAD (Tools for Oracle Application Developers) as I do writing SQR in SlickEdit. I rarely go beyond the twelve basic keywords (select, from, where, and, or, not, like, exists, order by, group by, in), but there are other syntactical choices. I’m not necessarily recommending them; they may be slower than the more familiar choices.
Last year I wrote about the similarity and superiority of the SQR evaluate command compared to the C or Java switch command in SQR Evaluate Versus C/Java Switch, part 1 and part 2. Here is another way to extend evaluate functionality.
Continue reading ‘Evaluate Two Values At Once In SQR’ »
I decided to begin this blog at the end of 2008 and published the first three entries on January 3, 2009. This is my 54th post, twelve months later.
Continue reading ‘A Year Of Blogging’ »
Last week we saw the origin of nine companies that owned or influenced the SQR programming language: Brio, D&N Systems, Hyperion, Oracle, Peoplesoft, Ray Ontko & Company, SQ Software, Sqribe, and Sybase. We saw the maturation of the feature set and what I called “The Golden Age” of MITI and Sqribe. In 1999 and beyond, SQR became part of an ever larger and more diverse product line.
Continue reading ‘SQR Timeline 1999 – 2009’ »
I wanted to write the history of SQR, but I can’t. I’ve reviewed dozens of press releases, news articles, websites, state government documents, and SEC filings to create this timeline. But that’s not a history; it’s missing key events that weren’t documented, or weren’t put online, or I just couldn’t find. It’s also missing explanations. I tried to track down the key people who contributed to the history of SQR. Even when I could find them, most of them didn’t respond to e-mails or phone messages. So, here’s what I have.
SQR and the Peoplesoft Process Scheduler work together to allow users to choose output format. The favorites in my organization are document (PDF) and spreadsheet (XLS). I mentioned this in 4 SQR Resolutions and I’ve had three readers ask me to elaborate. For this blog, that’s a tsunami of feedback.
Continue reading ‘How To Write Spreadsheets From SQR’ »
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’ »
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’ »