Select Page
Posted by Steven Alexander | Sep 13, 2009 | Algorithms, Peoplesoft Specific |
Last week, we considered change reporting based on the effective dates and action dates of PS_JOB. Other Peoplesoft tables track history differently. We need other approaches to report those changes. Benefit Changes Benefit...
Read MorePosted by Steven Alexander | Sep 6, 2009 | Algorithms, Peoplesoft Specific |
Most of my report and interface programs output snapshots of the database. Reports and interfaces about how the data has changed are more challenging. The effective date model of many Peoplesoft tables suggest that we can easily...
Read MorePosted by Steven Alexander | Aug 30, 2009 | Commands, Practices |
It’s not New Year’s Eve, but I have some resolutions to use more of the rich features of SQR to write programs that are richly featured themselves. More Color My internal customers are so used to monochrome, monofont...
Read MorePosted by Steven Alexander | Aug 23, 2009 | Algorithms |
Table-Driven programming is a technique that can make a program more easy to write or less easy to write, more clear or less clear, more maintainable or less maintainable. It can improve a program when we use it appropriately....
Read MorePosted by Steven Alexander | Aug 16, 2009 | Algorithms |
I wish SQL had a simple copy command. It would insert a new row into a table with almost all the values of an existing row of that table. Last week, we saw how to obtain data dictionary information from an Oracle database. This...
Read More
Recent Comments