September 6, 2009, 6:00 pm
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 extract the history of data, but the difference between effective dates and action dates, and the availability of correction mode complicate the issue.
Continue reading ‘Reporting Changes In Peoplesoft With SQR, Part 1’ »
August 30, 2009, 6:00 pm
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.
Continue reading ‘4 SQR Resolutions’ »
August 23, 2009, 6:00 pm
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.
Continue reading ‘Table Driven SQR’ »
August 16, 2009, 6:00 pm
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 week our program will help us specify our needs and write SQL for us.
Continue reading ‘SQL Copy Function In SQR, Part 2’ »
August 9, 2009, 6:00 pm
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.
Continue reading ‘SQL Copy Function In SQR, Part 1’ »
August 2, 2009, 6:00 pm
Of course we can use arrays like tables. What else can we do? Continue reading ‘Hooray For Arrays.Part(2)’ »
July 26, 2009, 6:00 pm
I’ve mentioned arrays while writing about other topics. It’s time I write about arrays. Someone could program in SQR for a whole career without ever using them, but that someone would have to work harder to do without these handy data objects. Continue reading ‘Hooray For Arrays.Part(1)’ »
July 19, 2009, 6:00 pm
Most people are more in favor of comments than they are in favor of writing comments. Most code doesn’t have enough comments, and the comments it has are often bad comments. Here are seven types of comments, listed from my favorite to my most disliked. Continue reading ‘7 Comments About Comments’ »
July 12, 2009, 6:00 pm
The only aspect of an SQR program that must be unique is its file name. The file name may also indicate something about the program within. There are restrictions on SQR program file names in the Peoplesoft environment, but there’s more flexibility than meets the eye. Continue reading ‘SQR Program File Names’ »
July 5, 2009, 6:00 pm
It is refreshing to have a new copy of the production database instance in the development database instance. It is also a bit frightening. Was anything important lost in the overwrite? Continue reading ‘Never Fear A Database Refresh Again’ »