SQR Variable Roles
I’ve written about variables several times (notably in Bottom #Ten Worst Variable Names and SQR Without Literals), but a recent entry on a new blog gave me a new way to think about them.
Continue reading ‘SQR Variable Roles’ »
Reporting Changes In Peoplesoft With SQR, Part 2
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.
Continue reading ‘Reporting Changes In Peoplesoft With SQR, Part 2’ »
Reporting Changes In Peoplesoft With SQR, Part 1
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’ »
4 SQR Resolutions
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’ »
Table Driven SQR
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’ »
SQL Copy Function In SQR, Part 2
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.
SQL Copy Function In SQR, Part 1
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’ »
Hooray For Arrays.Part(2)
Of course we can use arrays like tables. What else can we do? Continue reading ‘Hooray For Arrays.Part(2)’ »
Hooray For Arrays.Part(1)
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)’ »
7 Comments About Comments
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’ »