Select Page
Posted by Steven Alexander | Feb 22, 2009 | Commands |
Load-lookup and lookup are my favorite commands in SQR. I’m sorry if that hurts the feelings of all the other commands, but it can’t be helped. Load-lookup, how do I love thee? Let me count the ways. These commands are simple on...
Read MorePosted by Steven Alexander | Feb 15, 2009 | Algorithms, Peoplesoft Specific |
There are two things we can do after we quicksort an array. First, we can read it row by row, and the data will be in order. Second, we can use a binary search to find a specific row very, very quickly. Binary Search A binary...
Read MorePosted by Steven Alexander | Feb 8, 2009 | Algorithms |
We can’t always output information in the proper order by using the DBMS to sort the incoming data. Imagine a corporate roster showing who reports to whom. That’s going to require multiple selects of PS_EMPLOYEES. We could write...
Read MorePosted by Steven Alexander | Feb 1, 2009 | Algorithms, Commands |
Last week, in “SQR Evaluate Versus C/Java Switch, Part I,” we considered the overly modest claim that evaluate was equivalent to switch. Comparing the syntax of the two commands favored evaluate with a score of C/Java 1, SQR 3....
Read More
Recent Comments