Select Page
Posted by Steven Alexander | Jan 31, 2010 | Peoplesoft Specific, SQL |
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...
Read MorePosted by Steven Alexander | Jan 24, 2010 | Commands |
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...
Read MorePosted by Steven Alexander | Jan 17, 2010 | Peoplesoft Specific, SQL |
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...
Read MorePosted by Steven Alexander | Jan 10, 2010 | SQL |
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...
Read MorePosted by Steven Alexander | Jan 3, 2010 | Algorithms, Commands, Practices |
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...
Read More
Recent Comments