Archive for March 2009

3 Types of SQR Variables in SQL Statements

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

Bottom #Ten Worst Variable Names

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

5 Uses: Load-Lookup Love Letter

13 DDO Parameters: 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’ »

9 SQL Parameters: Load-Lookup Love Letter


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