Archive for January 2010

Views You Can Use: Position Data

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’ »

A Strange SQR Bug

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’ »

Views You Can Use: Leave Accrual

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’ »

Little Known SQL Syntax

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.

Continue reading ‘Little Known SQL Syntax’ »

Evaluate Two Values At Once In SQR

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’ »