Select Page
Posted by Steven Alexander | Mar 29, 2009 | Commands |
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...
Read MorePosted by Steven Alexander | Mar 22, 2009 | Practices |
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. 1. Nondescript Loop Counters move 0 to #i while #i...
Read MorePosted by Steven Alexander | Mar 15, 2009 | Algorithms, Commands |
The adventure begins – finally! I chose “Load-Lookup and Lookup” as a topic to discuss the wonderful things we can do with these commands. I realized that not everyone knows everything about these commands, so I’ve written...
Read MorePosted by Steven Alexander | Mar 8, 2009 | Commands |
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...
Read MorePosted by Steven Alexander | Mar 1, 2009 | Commands |
Parameters Load-lookup takes four to nine parameters. The syntax looks like this. load-lookup name= table= key= return_value= rows= extent= where= sort= quiet The parameters may be in any order. If a parameter...
Read More
Recent Comments