Re: QMQRY QQRYSRC issues group by and order by

Chuck

I now understand better what you are saying. I think we're looking at this elephant like the 6 blind men - seeing only a part of the whole.

I see what you mean - that probably the *PRV objects are a kind of stub - I'd probably thought mistakenly that they were the commands that were used - and now I see that that made little sense.

On the other hand, I was hoping to give the OP some hope that they once had a licensed copy of ST1 installed - otherwise the *PRV objects would not be there. This under another assumption - namely, that previous CL support doesn't put objects in unless the product is already installed. But that does not necessarily follow, either. In fact, I just ran a comparison between a *PRV support object list and the current objects - lots of things not installed on our box. So once again we see what ASSUME means!

Learning more every day - thanks!
Vern

-------------- Original message --------------
From: CRPence <CRPbottle@xxxxxxxxx>

It was not so important to clarify; I should not have commented :-!
esp. not a second time.

Regardless, I will try again, based on the most recent response; from
which I think I have gained a new insight to your perspective. AFaIK
the ST1 product can only be installed into the one library, QSQL; that
it is not supported to install into any other library. As such the
product could not have more than one release installed. Thus I do not
think the commands are "early release objects" but instead, that they
are [essentially] current release objects, that are providing support
for TGTRLS(*PRV) CL compiler support.

The CL Previous release compiler support has two QSYSV#R#M#
libraries, because there are two release levels against which the
compile can be directed; i.e. compiler support for TGTRLS of both N-1
and N-2. Up to two copies of the commands could exist, one in each of
the QSYSV#R#M#. I am trying to imply that those copies of the STRSQL
command, originally noted to exist "for two prior releases" [older
quoted message snippet added] on the system for the OP, are apparently
those copies of the command in the IBM-supplied Previous Release CL
compiler libraries [that will contain the same list of commands on all
systems where those libraries are an installed LPP].

Of course my original comments *assumed* that what the OP meant, was
the copies of the commands were in the QSYSV#R#M# libraries. As such my
attempts to clarify could have easily been way off base... if multiple
copies of QSQL can exist. And besides, as I noted in my opening, it is
hardly worth the effort to ensure clarification anyway.

Regards, Chuck

vhamberg@xxxxxxxxxxx wrote:

I apparently was not clear - I meant the the presence of early
release objects MIGHT imply that they once had the licensed
product installed - and it seems it is present in more than 1.
So it seems someone might have removed it or not installed it.
Of course, it might have been installed for try&buy
- but in 2 different releases? Hmmm! <>

Frances Denoncourt (27-Aug 18:48) wrote:

No STRSQL command for this release - but there it is in the
libraries for two prior releases. I am SO tempted to just
copy it to current <>

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.