#22 Rexx/SQL for ooREXX 4.1.0

[John Potelle]

I’ve been using Rexx/SQL 2.5 for several years with Regina but I’d like to move my REXX code to ooREXX; it seems to execute programs faster. I see that the old w32funcs and Regina REXX Utility Functions have been rolled into ooREXX. But I also need SQL functionality and I can’t make Rexx/SQL 2.5 work with ooREXX 4.1.0 (though you note that ooREXX support was added in v2.5). I found Rexx/SQL 2.6b2 on Sourceforge but I can’t compile it; I’m not even sure it’ll work. Also John Blumel’s ORexx/SQL classes seem to be a wrapper around Rexx/SQL so I doubt that would help me. Lee Peedin’s “Using Procedural Rexx/SQL as an OORexx Object” code also doesn’t work.

RxFuncAdd('SQLLoadFuncs','rexxsql','SQLLoadFuncs') returns 0 but RxFuncQuery() returns 1 for every function listed in the Rexx/SQL docs http://rexxsql.sourceforge.net/doc/index.html except SQLLoadFuncs. And sqlversion = sqlvariable('VERSION'); triggers Error 43.1: Could not find routine "SQLVARIABLE";

Does Rexx/SQL 2.6b2 work with ooREXX 4.1.0? If so, when do you think 2.6 will be released from beta?

Thanks for your help!

[John Potelle]

Simple test program