>as our VM mainframe is soon going to die I'm rewriting all my CMS REXX
>programs using REGINA and REXXSQL on Windows XP.
>As I have to rewrite the code I would like to brush it up and replace
>those QUERYs with SELECTs.
Thomas - A couple of observations...
- I would caution avoiding going to Selects, which seem the "chic" thing
to do these days. Query commands are more optimized for directly going
into the TSM database to rapidly return results: Selects go through an
artificial SQL construct on top of the actual B-tree database and
entail considerable overhead - including database workspace.
For example, contrast a Query CONTent with Select ... From Contents.
Query commands are not passe: they are simply pre-programmed and that
much less flexible.
- Your VM mainframe went away because of obsolescence. REXX is in the
same category. (And I say this having been a VM guy and huge fan of
REXX.) I would encourage you to get into Perl, which is available on
every platform, and is now intrinsically supplied with more open
operating systems these days.
Richard Sims, BU
