Peoplesoft and SQR

Here are some small but significant ways to speed up or streamline your SQR program. Continue reading ‘7 Little SQL Tricks’ »

The term “log file” implies that this file serves as a log; a diary; a record of significant events in the program. It’s a place for unofficial information or information about this instance of this program, not to be stored in the organization’s production database for widespread access and not to be printed in reports for the system’s customers. It’s information for the technical team to use for troubleshooting or analysis. Continue reading ‘4 Building Blocks Of SQR Log Files’ »

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

Even the best programmer in my one-person cubicle makes mistakes. I’ve worked in several different languages, and made the same mistakes in many of them; out of bounds array index, dividing by zero, messing with Texas. Continue reading ‘7 Uniquely SQR Bugs’ »

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’ »

SQR programs can execute SQL “select” statements with a “begin-select … end-select” block. They can execute any other SQL statements with a “begin-sql … end-sql” block. SQR has three ways to modify the literal text of those SQL statements. Continue reading ‘3 Types of SQR Variables in SQL Statements’ »

Well chosen variable names are crucial for understanding what a program is doing.  I plan to write about naming well but for now, it’s more fun to criticize bad variable names. Continue reading ‘Bottom #Ten Worst Variable Names’ »

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

I don’t have experience with SQR for DDO (Direct Data Object), which supports JDBC, SAP BW, SAP R/3, Essbase, MS-OLAP, XML, and CSV. I’ve studied several versions of the SQR Language Reference and tried to extrapolate from the SQL version of load-lookup. Continue reading ‘13 DDO Parameters: Load-Lookup Love Letter’ »

Parameters

Load-lookup takes four to nine parameters. The syntax looks like this. Continue reading ‘9 SQL Parameters: Load-Lookup Love Letter’ »