When Peoplebooks Is Not Enough
Views are a useful feature of SQL databases, letting us create virtual tables based on SQL select statements. The Peoplesoft Application Designer also lets us create dynamic views, which we may use within the page processor.
Some organizations manage their workforces with positions. A position specifies a job and a place on an organization chart, which can exist without a person or with more than one person. Position management can give organizations more control over their structures, budgeting, and succession planning.
Continue reading ‘Views You Can Use: Position Data’ »
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’ »