While working on a problem for a client I found that most version of SQR do not support UTF-8 character sets directly, some of the newest version can do this. I wrote a handy little SQC to handle the conversion of string between UTF-8 and ASCII [here].

Every once in a while, there has been a need for using random numbers in an SQR, unfortunately, SQR does not have such a procedure. To compound the problem, most good PRNG need to use bit level operations, also which SQR does not support very well. I had already built a binary math library (accsl004) so I added a few more procedures to this and created a new library (accsl011) (see the source code library for the files). This library implements the TT800 PRNG originally written by M. Matsumoto,

Read full article: 'SQR Linear Pseudorandom Number Generator'

I have uploaded a new version of my SQR orphan checker program [here] that now allows you to supress the output of the "0 orphan" record information on the printed report. Great when you are doing a full database scan.

Read full article: 'SQR Orphan Checker'