Select Page
Posted by Steven Alexander | May 31, 2009 | Algorithms, Peoplesoft Specific |
SQR is a language primarily for batch processing, but it does have limited support for real time, interactive applications. Let’s build a process monitor that is better than (or at least different from) Peoplesoft’s...
Read MorePosted by Steven Alexander | May 24, 2009 | Practices |
Most programs are sprinkled with literal values; 11, ‘USA’, ’01-JUL-2007′, etc. Sometimes we can guess their meanings from context. while #sales_office <= 11 let $country = ‘USA’ where...
Read MorePosted by Steven Alexander | May 17, 2009 | Commands |
As much as I like SQR, I am reluctantly willing to admit that it is not perfect. Ray Ontko, one of the pioneers of SQR, listed his ideas for improvements on his company’s website. Here’s my wish list. Given the...
Read MorePosted by Steven Alexander | May 10, 2009 | Practices |
What do compilers expect of the programs we create? Our programs should follow the syntax of the language and observe the practical limits of the compiler. What do our customers and managers expect of the programs we create? Our...
Read MorePosted by Steven Alexander | May 3, 2009 | Algorithms, Peoplesoft Specific, SQL |
Here are some small but significant ways to speed up or streamline your SQR program. 1. Select Before Delete In every pay period we added 200,000 rows to a table that already had twenty million rows. This process had to be...
Read More
Recent Comments