ADSM-L

Re: SELECT equivalent for QUERY EVENT

2003-06-23 14:36:57
Subject: Re: SELECT equivalent for QUERY EVENT
From: Richard Sims <rbs AT BU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 23 Jun 2003 14:36:34 -0400
>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

<Prev in Thread] Current Thread [Next in Thread>