Peoplesoft and SQR

Numbers are probably the most important scalar objects of business applications, but dates may be a close second. Continue reading ‘SQR Dates’ »

Peoplesoft allows the user to give direction to an SQR program by entering parameters on a webpage before the Process Scheduler runs PSSQR. Here is a new way to get those parameters to the SQR program. Continue reading ‘How To Read Peoplesoft Run Control Parameters In SQR’ »

The adventure begins – finally! Continue reading ‘5 Uses: Load-Lookup Love Letter’ »

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. Continue reading ‘Array Searches in Peoplesoft SQR’ »

We can’t always output information in the proper order by using the DBMS to sort the incoming data. Continue reading ‘Quicksort For SQR’ »

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. Now the competition moves to the “usefulness” test. Continue reading ‘SQR Evaluate Versus C/Java Switch, Part J*’ »

It’s not that hard for a busy Peoplesoft user accidently to run an SQR program, or any other batch process, twice. Continue reading ‘How To Prevent An SQR Program From Running Twice’ »

Sometimes we have a fully qualified filename (drive letter, path, filename, and extension) and we need to parse it.  Continue reading ‘How To Parse A Filename in SQR’ »